topic Set Analysis in QlikView

Set Analysis

deepali_more — Sun, 13 Dec 2015 07:47:56 GMT

Hi all i am beginner to Qlikview development and i have a question: How can we make set analysis dynamic? if i want to show data for previous 5 years for particular dates from different months..assuming sales to be measure ..then how will that expression will be like?

Re: Set Analysis

maxgro — Sun, 13 Dec 2015 16:25:14 GMT

Could you add an example (ie source data, expected result)?

Just 1 thing: set analysis is calculated once per chart (not once per row).

Re: Set Analysis

marcus_sommer — Sun, 13 Dec 2015 16:26:57 GMT

You could use calculations within the set analysis like:

sum({< Year = {">=max(Year) - 5"}>} value)

See here for various examples on set analysis: Set Analysis: syntaxes, examples

- Marcus

Re: Set Analysis

deepali_more — Mon, 14 Dec 2015 06:03:31 GMT

Hi Marcus,

It is useful answer but i want to say..what if i want to have data for year 2010 to 2015 , for months = March,May,Nov, Dec and for dates

For March = 1 to 15

For May= 14 to 20

For Nov = 15 to 30

and for Dec = 1 to 30

how can we achieve this? it won'tbe good idea to give all these condition in modifier..right?

please correct me if i am wrong.

Re: Set Analysis

Anonymous — Mon, 14 Dec 2015 06:12:03 GMT

check this:

Set Analysis for Rolling Periods

Learning Set Analysis from Scratch

A Primer on Set Analysis

http://www.learnqlickview.com/qlikview-set-analysis-basics/

Hope this will help you!!

Re: Set Analysis

vikasmahajan — Mon, 14 Dec 2015 06:48:46 GMT

Deepa PFA Document very useful for set analysis

Vikas

Re: Set Analysis

marcus_sommer — Mon, 14 Dec 2015 09:46:33 GMT

You could use as many fields you need within the set analysis to dertermine which data should be considered for those calculations and each of them could be a calculation which returned a dataset based on the current selections or ignore parts of them. Quite often are the set analysis function p() and e() very useful for such a doing.

In your case I would use - maybe additionally - fields (created within a master calendar) like DayInYear or DateWithoutYear and then:

sum({< Year = {">=max(Year) - 5"}, p(DateWithoutYear) >} value)

- Marcus