Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one explain me 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.