topic Period before the selection in QlikView

Period before the selection

Anonymous — Fri, 23 Dec 2011 18:11:50 GMT

How to bring the sum of the previous selection?

If I select two months, should return two months prior to selection.

example:

12/2011 and 11/2011

returns 10/2011 and 09/2011.

swuehl — Fri, 23 Dec 2011 22:09:44 GMT

You can use a set expression to set DATA to the time period you want.

=SUM({<DATA = {">=$(=Date(addmonths(min(DATA),-2),'MM/YYYY'))<=$(=Date(addmonths(max( DATA),-2),'MM/YYYY'))"}>} VALOR)

Please see attached.