Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview world ,
can one help me out form this topic.
hi @prabhakar G
please check out the document about set analysis
and see this link with clear example with clear understandable words about set analysis
http://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/
See this blog post: A Primer on Set Analysis
Hi,
Hope this attachment helps you completely.
Qlikview charts calculates based on the Current selections we did in the filters. Sometimes we need to override this, for this we will use Set Analysis.
For example based on the selected year, we need to display the Last 5 years data, for this we use below expression
=Sum({<Year={'>=$(=Max(Year) - 4)'}>} Sales)
PFA file, hope it helps you..
Regards,
Jagan.