topic Re: What is Set Analysis? in QlikView

What is Set Analysis?

naveenchellaara — Sat, 23 Feb 2013 05:24:58 GMT

What is Set Analysis?

Is it used only for aggregation?

Re: What is Set Analysis?

phaneendra_kunc — Sat, 23 Feb 2013 05:31:10 GMT

i would say its better go through the community...there are numerous examples, definitions, etc....

Below will be a good start..

http://community.qlik.com/docs/DOC-1867

Re: What is Set Analysis?

whiteline — Sat, 23 Feb 2013 09:25:47 GMT

Hi.

Have you read QlikView help for 'Set Analysis' ?

Re: What is Set Analysis?

Gabriel — Sat, 23 Feb 2013 09:31:47 GMT

Hi,

Set analysis is very powerful.

Set Analysis is a great feature in QlikView that lets you, as a developer, take control over what your charts display and allows calculations that wouldn't be possible otherwise, at least not as dynamically. To understand its inner workings, we can compare it to how selections that are made using listboxes work.

With UI selections, we can say that whatever is selected affects the entire document, and all of the charts only display information associated with the set of data corresponding to those selections; plain and simple. In a way, that is basically what Set Analysis does. It restricts, predefines, or extends the set of data that charts base their calculations on. Using a set expression, we can, for instance, specify that a certain chart should perform an aggregation only based on records that meet a set of criteria in certain fields (for example, Region A and Region B from the Region field), even if the non-matching values are part of the user's selected record set. We can also use Set Analysis to expand the selections made by the user to show, for example, results of the previous year even when it has not been actually selected. For example, when the user selects the year 2012 and a table displays data for 2012 in one column and 2011 in the other.

Hope this helps

Regards

Gabriel

Re: What is Set Analysis?

dmohanty — Sat, 23 Feb 2013 09:39:29 GMT

QlikLearn-Set-Analysis-Presentation.pdf

Please refer this.

Re: What is Set Analysis?

naveenchellaara — Sat, 23 Feb 2013 09:48:13 GMT

Thanks Gabriel. That was a very good explanation. Thanks a lot for the Response

Regards

Naveenchellaaraam

Re: What is Set Analysis?

Anonymous — Tue, 28 Feb 2017 11:13:20 GMT

I tried to access your link to the qliklearn-set-analysis-presentation.pdf but it came up with: "Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here."

Please advise?