topic Re: Set Analysis in QlikView

Set Analysis

spividori — Tue, 23 Oct 2012 21:20:25 GMT

HI!

In my example I have a table with dates and quantity.
I read the date as Month Year and then arm a bar graph with this dimension.
Need for each dimension that adds the previous two.
For example: in June 12 should add April 12, May 12 and June 12.
I wish I could do it with Set Analysis.

Regards.

Re: Set Analysis

MayilVahanan — Tue, 23 Oct 2012 21:27:27 GMT

I can't able to see the fields in your example file.. Try like this

=sum({<Date = {'>=$(=vTest)<=$(=vTest1)'}>}Quantity)

where vTest = AddMonths(Min(Date),-2)

vTest1 = Max(Date)

Re: Set Analysis

swuehl — Tue, 23 Oct 2012 21:32:05 GMT

Set analysis won't consider your current dimension value, because it's evaluated once per chart.

I think the way to go is using chart inter record functions like above().

Try something like

=rangesum(above(sum(Quantity),0,3))

edit: changed 2 to 3, you requested summing 3 Months..

Re: Set Analysis

spividori — Tue, 23 Oct 2012 21:37:35 GMT

Sorry
Here is my example with data.

Regards.

Re: Set Analysis

johnw — Tue, 23 Oct 2012 21:44:26 GMT

Unless I'm misunderstanding, just set Accumulate 3 Steps Back on the Expressions tab. That seems like the easy way, anyway.

Re: Set Analysis

spividori — Wed, 24 Oct 2012 09:29:52 GMT

I tried also to select a month you also add the three above.

But will use the rangesum (). Thank you all.

Regards.