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.
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
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.