topic Help with Set analysis in QlikView

Help with Set analysis

Fri, 31 Jul 2015 09:48:17 GMT

Hi,

My requirement is to get records of previous year when a particulat year is selected .

Sum of Sales

For the same, I have written the following code

sum({<CurrYear={$(=CurrYear-1)} >}Sales).

So if Curryear is selected as 2015 then i should sum up 2014 records. The formula is working fine when a particular year is selected.

BUt I have a chart where my Curryear is the dimension and my above formula is failing and returning 0.

Chart is Bar chart and the dimension is Curryear (2013,2014,2015, etc). For all years it is showing as 0

Can any one help on this problem? I think we need to change the set analysis, CurrYear = ???

BR,

Neehu

Re: Help with Set analysis

Gysbert_Wassenaar — Fri, 31 Jul 2015 09:51:49 GMT

The set of a set analysis expression is calculated at the chart level, not at the row level. That's why your expression doesn't work with Curryear as dimension unless you select only one value in the Curryear dimension. You can try one of the approaches described in this document: Calculating rolling n-period totals, averages or other aggregations

Re: Help with Set analysis

jonathandienst — Fri, 31 Jul 2015 09:53:10 GMT

You cannot use a set expression like that. The set expression is calculated once for the chart/table and has no knowledge of the dimension values.