Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

What is set analysis.

Can any one explain me what is set analysis

3 Replies

Re: What is set analysis.


Qlikview/Qliksense works based on the selections done, for example let us assume in a Sales Dashboard we have a year field with 2012, 2103, 2014, 2015 and 2016.  If you select 2016 then all the charts will display sales for 2016, sometimes we need to override this.  For example sales last 5 years from selected year then we have to override the selections by using the set analysis expression like below

=Sum({<Year={'>=$(=Max(Year) - 4)<=$(=Max(Year))'}>} Sales)

You can find some sample expressions from below link

Set Analysis: syntaxes, examples

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Refer Qlikview/Qliksense help file for more details and examples on this.

Hope this helps you.



Honored Contributor II

Re: What is set analysis.

Hi Sumit,

This should be really helpfull.

A Primer on Set Analysis



Community Browser