Advanced Expressions in Qlik Sense

Expressions are an essential part of any chart. There would be no output without expressions, and the results of any output will be conditioned by the accuracy of the expressions.

We usually find expressions in the script as well as in any chart. We described script expressions in Chapter 8, Advanced Scripting, and we will cover chart expressions in more detail in this chapter.

An expression can be defined as a group of functions, fields, and operators that, after being evaluated, will return a number or string. We can find expressions not only within the measures of any chart but also in labels, titles, and so on. If you see the icon  in a chart, it means that not only a string but also an expression can be used.

The following is an example of an expression:

SUM( [Gross Sales] * 1.2 )

The previous expression contains three elements: 

  • The function: SUM() 
  • The field: [Gross Sales]
  • The mathematical operator: *

After the mathematical operator, we also have a constant number, 1.2. This expression will return a number for Gross Sales + VAT of 20%.

Simple expressions are not always enough to analyze complex datasets. Set analysis allows us to talk to the Qlik engine and manipulate datasets to obtain results beyond the user's selections.

In this chapter, you will master expressions by learning about the following:

  • Set analysis: What it is and how to use it.
  • Variables: How to correctly create, use, and maintain variables throughout an application to make your dashboards powerful and flexible.
  • Maintaining expressions: How to efficiently maintain expressions in a project.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.17.79.206