topic Set Analysis -- LastYear/LastMonth in QlikView

Set Analysis -- LastYear/LastMonth

Fri, 17 Feb 2012 10:36:45 GMT

Hi...

I would like when I click on Year on my selection List Sum Qty for year = Year-1 and Month = Month(Max(Month)-1)

Example : I clik on Year = 2012 [2011 -- NOV.] (selection list)

I obtain a calculation like : Sum (Qty) for {Year=2011;nov.} in dynamic.

lironbaram — Fri, 17 Feb 2012 10:40:52 GMT

for the whole last year use

sum({<Year={"$(=max(Year)-1)"}, Month=>} Qty)

for same month in last year use

sum({<Year={"$(=max(Year)-1)"}>} Qty)

CELAMBARASAN — Fri, 17 Feb 2012 10:41:43 GMT

Hi,

Use set analysis for this type of problem.

=Sum({<Year={$(=Max(Year)-1)},Month={'$(=if(GetSelectedCount(Month)>0,Month(AddMonths(Max(Date),-1)),'*'))'}>} Qty)

Hope it helps

Celambarasan

Fri, 17 Feb 2012 10:56:48 GMT

Thank you. I'll test it !!