Set Analysis

[#1]

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

[Gysbert_Wassenaar]

See this discussion: Re: Set Analysis

[sujeetsingh]

Have a complete go through to this document.

[#4]

Thanks Mr. Sujeet.

[#5]

Thanks Mr. Gysbert

[suresh_rawat]

Hi Praveen,

Kindly refer this PPT it will help you to learn set analysis.

Regards

Suresh Rawat

[#7]

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.

[vikasmahajan]

More find qvw file for set analysis.

Vikas

[sujeetsingh]

You are always Welcome !!

[mjm · Accepted solution]

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,