Mastering Qlik Sense

Using variables in set analysis

We have already explained set analysis and its different parts. Variables can also be used within set analysis. Simply replace part of the set analysis with the variable you want. It is recommended to use variables in set analysis in the modifiers.

Say you had a variable that contains today's date:

LET vToday = today();

You can replace the following chart expression with the vToday variable:

sum({$< Date = {$(vToday)} }> Balance)

Not only can you use variables to replace values in set modifiers but you can also replace the whole set with variables. For example, you may calculate the sales of a certain region for the current year in different charts. Instead of replicating the same expression chart over and ...