topic Set Analysis in QlikView

Set Analysis

spividori — Tue, 15 Oct 2013 13:21:06 GMT

HI.

I have two fields: AñoMes and Cantidad. I need to show me the sum of the latest four months.

You should take as latest month, the month of the date actual. In the attached example would be taking Oct 13, Aug 13, Sep 13 and July 13.

Must be independent of any selection, if I choose Jan 13, these values should not be modified.

Regards.

tresB — Tue, 15 Oct 2013 13:30:11 GMT

PFA

swuehl — Tue, 15 Oct 2013 13:32:14 GMT

Maybe like attached, using this expression:

Sum({<

AñoMes = {">=$(=date(addmonths(max({1}AñoMes),-3),'MMM YY'))<=$(=date(max({1}AñoMes),'MMM YY'))"}

>} Cantidad)

spividori — Tue, 15 Oct 2013 13:46:10 GMT

Hi.

Thanks for responding.The two examples work perfect.

Regards.