Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Need help with expression

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Need help with expression

Try using

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

or if your period dimension is pivoted to the top:

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

2 Replies
MVP
MVP

Re: Need help with expression

Try using

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

or if your period dimension is pivoted to the top:

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

Not applicable

Re: Need help with expression

Thanks swuehl

Community Browser