Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am have less expertise in Qlikview. Can anyone help me out in learning Set Analysis.?
Can any one provide me an easy document to learn it ?
Regards,
Praveen
Hello,
I use this QV Application in the early stages to help build my Set Analysis statements. Please see attached file.
I am also attaching a beginner's guide which helps explain things better.
Please mark as helpful if this helps.
Thanks,
See this discussion: Re: Set Analysis
Have a complete go through to this document.
Thanks Mr. Sujeet.
Thanks Mr. Gysbert
Hi Praveen,
Kindly refer this PPT it will help you to learn set analysis.
Regards
Suresh Rawat
Hi Praveen,
Do you remember the magic of Venn diagram we studied in school?
Find the image attached.
Set analysis is basically used in aggregation function.Qlikview basically works on the associative model which means based on your current selection.But when you define set analysis, it has nothing to do with current selection.Only works on the set defined by you.
Set analysis starts and ends with {}
e.g- Sum({<Sales={'1001','1002','1003','1004'}>}Sales_ID)
http://www.learnqlickview.com/qlikview-set-analysis-basics/
May be the above link can be helpfull for you.
More find qvw file for set analysis.
Vikas
You are always Welcome !!
Hello,
I use this QV Application in the early stages to help build my Set Analysis statements. Please see attached file.
I am also attaching a beginner's guide which helps explain things better.
Please mark as helpful if this helps.
Thanks,