Simple play icon Course

Using Expressions in Qlik Sense

by Janani Ravi

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

Course Overview

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

Ready to upskill? Get started