In this chapter, we will focus on the concept of Set Analysis and its use in Qlik Sense. We will cover the following topics:
=
sign with variables in Set Analysisconcat()
function in Set AnalysisP()
and E()
in Set AnalysisI will say it outright that Set Analysis is one of the most important technical features of Qlik solutions. It allows you to do things dynamically that just won't be possible with the default selections you have made. Set analysis can be termed as Selection analysis. The user tells Qlik Sense what set of records need to be picked for calculation which is similar to making a selection from a Filter pane or active objects. The only difference is that you define the selection inside the calculation. So that the expression can still look at the records you specified inside the Set Analysis expression even if you clear all the default selections.