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

Re: What is set analysis.

Hi,

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.


Regards,

Jagan.

reddys310
Honored Contributor II

Re: What is set analysis.

Hi Sumit,

This should be really helpfull.

A Primer on Set Analysis

Thanks,

Sangram.

Community Browser