- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- new_to_qlikview
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using
=rangesum(above(sum(Amount),0,rowno() )
or if your period dimension is pivoted to the top:
=rangesum(before(sum(Amount),0,rowno() )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using
=rangesum(above(sum(Amount),0,rowno() )
or if your period dimension is pivoted to the top:
=rangesum(before(sum(Amount),0,rowno() )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks swuehl