topic Re: Set Analysis in QlikView

Set Analysis

Fri, 27 Dec 2013 06:46:25 GMT

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

Re: Set Analysis

Gysbert_Wassenaar — Fri, 27 Dec 2013 06:55:39 GMT

See this discussion: Re: Set Analysis

Re: Set Analysis

sujeetsingh — Fri, 27 Dec 2013 07:00:03 GMT

Have a complete go through to this document.

Re: Set Analysis

Fri, 27 Dec 2013 07:02:49 GMT

Thanks Mr. Sujeet.

Re: Set Analysis

Fri, 27 Dec 2013 07:03:10 GMT

Thanks Mr. Gysbert

Re: Set Analysis

suresh_rawat — Fri, 27 Dec 2013 07:15:36 GMT

Hi Praveen,

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

Regards

Suresh Rawat

Re: Set Analysis

Fri, 27 Dec 2013 07:24:26 GMT

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.

Re: Set Analysis

vikasmahajan — Fri, 27 Dec 2013 07:26:59 GMT

More find qvw file for set analysis.

Vikas

Re: Set Analysis

sujeetsingh — Fri, 27 Dec 2013 08:10:57 GMT

You are always Welcome !!

Re: Set Analysis

mjm — Fri, 27 Dec 2013 14:29:16 GMT

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,

Re: Set Analysis

Fri, 03 Jan 2014 10:29:50 GMT

Thanks

Re: Set Analysis

Fri, 03 Jan 2014 10:31:14 GMT

Thanks Mr. Tripathy

Re: Set Analysis

Fri, 03 Jan 2014 10:31:36 GMT

Thanks Vikas

Re: Set Analysis

Fri, 03 Jan 2014 10:32:23 GMT

Thanks James