Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is set analysis, can any one provide clear picture for this ?

Hi Qlikview world ,

can one help me out form this topic.

6 Replies
Not applicable
Author

hi @prabhakar G

please check out the document about set analysis

Set Analysis 1.pdf

and see this link with clear example with clear understandable words about set analysis

http://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

Gysbert_Wassenaar

See this blog post: A Primer on Set Analysis


talk is cheap, supply exceeds demand
krishna20
Specialist II
Specialist II

Hi,

Hope this attachment helps you completely.

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

Hi,

Please go through this link:

Set analysis