Indirect set analysis

Anonymous — Tue, 03 Sep 2013 12:31:40 GMT

Hi all,

I need to create a set analysis.

Suppose I have 2 years in my data base, 2012 and 2013.

I have a pivot table and I have a set analysis like this:

Sum({<YEAR={'$(=max(YEAR))'}>} QTY)

so, I have the quantity for year 2013 and month gen-feb-mar-apr-may-jun-jul-aug-sep (because we're in 2013 sept.)

Now i need a set analysis that calculate the amount of last year (Sum({<YEAR={'$(=max(YEAR)-1)'}>} QTY)) but only for the months excluded from the current selection: year 2012 months oct-nov-dec

Is it possible? I tought about indirect set analysis but I'm not able to write a correct formula.

How can I do that?

Thank you very much!

Re: Indirect set analysis

michael_maeuser — Tue, 03 Sep 2013 12:38:05 GMT

just create a variable vTest= month(today()) and add to your expression for previous year Month={'>=$(vTest)'}

Re: Indirect set analysis

Gysbert_Wassenaar — Tue, 03 Sep 2013 12:52:04 GMT

See attached example.

topic Re: Indirect set analysis in QlikView

Indirect set analysis

Re: Indirect set analysis

Re: Indirect set analysis