Using Expressions in Qlik Sense
The insights present in data are often the result of fairly complex calculations, and Qlik Sense expressions allow you to construct such calculations in a step-by-step manner. The results are dynamic and will be updated as underlying data changes.
What you'll learn
Qlik Sense expressions allow you to create not just dynamic charts but also chart elements such as titles, subtitles, footnotes and even dimensions - which then update as the underlying data changes. In this course, Using Expressions in Qlik Sense, you will learn to build visualizations with simple and complex expressions and perform comparative analysis using set analysis to make your dashboards and reports even more powerful and compelling. First, you will explore using expressions in basic chart elements such as labels, titles, subtitles and reference lines. Then, you will create reusable containers for data and calculations using variables and reference them in expressions. Next, you will study a range of built-in functions available in Qlik Sense including date time functions, string functions, conditional evaluation, and categorization of numeric values into bins. Finally, you will work with set analysis and set expressions to understand the use of the $, 1, and the 1-$ identifiers, and work with a range of modifiers and operators to perform comparative analysis. By the end of this course, you will be comfortable using expressions, variables, and set analysis in your Qlik Sense charts and sheets
Table of contents
- Module Overview 1m
- Prerequisites and Course Outline 1m
- Introducing Expressions 2m
- Exploring the Dataset 4m
- Exploring the Expressions Editor 7m
- Autosuggest and Help in the Expressions Editor 3m
- Building Simple Expressions Using the Expressions Editor 6m
- Using Complex Expressions in Charts 5m
- Working with the if() Condition 4m
- Using Expressions in Titles, Subtitles and, Footnotes 5m
- Using Expressions in Reference Lines 4m
- Using Expressions to Sort Data 5m
- Using Expressions to Assign Colors 5m
- Module Overview 1m
- Introducing Functions 2m
- Working with Date and Time Functions 9m
- Extracting Detail from Dates 4m
- Using a Class Function to Generate Categories 4m
- The Alt and Pick Function 5m
- The Match, MixMatch, and WildMatch Function 4m
- Working with String Functions 4m
- More String Functions 3m
- Using the Class Function as a Dimension 4m
- Using the Class and Aggr Function in Dimensions 6m
- Nesting Aggregations Using the Aggr Function 4m
- Module Overview 1m
- Understanding Set Expressions and Set Analysis 8m
- Set Analysis Using Set Expressions 7m
- Configuring Set Expressions Using Current Selections and Bookmarks 7m
- Configuring Set Expressions Using Alternate States 4m
- Using the $ and 1 Identifier 7m
- The 1-$ Identifier 3m
- Using Bookmarks as Identifiers 3m
- Using Variables in Set Expressions 3m
- Working with Operators in Set Expressions 6m
- Advanced Set Analysis 3m
- Summary and Further Study 2m
About the author
Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing ... more