Need help with expression

Tue, 31 Jul 2012 11:28:08 GMT

I have to show the data in pivot table in my QlikView report as shown below

Period Amount

-------------------------------------

4/1/2012 360

5/1/2012 1000

6/1/2012 1500

The actual amount values for period

5/1/2012 is 640 and for 6/1/2012 is 500.

To make it possible (ie. current period amount + previous period amount), I am using expression

=sum(Amount) + sum( {$<Period=$(vPrevMonth)>} Amount)

and vPrevMonth is calculated as addmonths(Period,-1)

Not sure my approach is right or not, but somehow the expression is not working. Please suugest the way to achieve this in QlikView.

Thanks.

Re: Need help with expression

swuehl — Tue, 31 Jul 2012 11:37:05 GMT

Try using

=rangesum(above(sum(Amount),0,rowno() )

or if your period dimension is pivoted to the top:

=rangesum(before(sum(Amount),0,rowno() )

Tue, 31 Jul 2012 12:48:19 GMT

Thanks swuehl