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.
Course info
Level
Intermediate
Updated
Mar 26, 2019
Duration
2h 56m
Table of contents
Course Overview
Using Expressions in Charts
Creating Dynamic Expressions Using Variables
Transforming and Aggregating Data with Functions
Applying Set Analysis to Group Data Values
Description
Course info
Level
Intermediate
Updated
Mar 26, 2019
Duration
2h 56m
Description

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

About the author
About the author

A problem solver at heart, 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.

More from the author
Building Features from Image Data
Advanced
2h 10m
Aug 13, 2019
Designing a Machine Learning Model
Intermediate
3h 25m
Aug 13, 2019
More courses by Janani Ravi
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi. My name is Janani Ravi, and welcome to this course on using expressions in Qlik Sense. A little about myself, I have a master's degree in electrical engineering from Stanford and have worked at companies such as Microsoft, Google, and Flipkart. At Google, I was one of the first engineers working on real-time collaborative editing in Google Docs, and I hold four patents for its underlying technologies. I currently work on my own startup, Loonycorn, a studio for high-quality video content. In this course, 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. We'll start off by exploring the expression editor and using expressions in basic chart elements such as labels, titles, subtitles, and reference lines. We'll then create reusable containers for data and calculations using variables and reference these variables in expressions. We will then study in detail a range of built-in functions available in Qlik Sense including DateTime functions and string functions. We'll perform conditional evaluation using the if, alt, pick, and match functions and categorize our numeric values into bins using the class function. Finally, we'll round off our learning by working with set analysis and set expressions. We'll 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.