Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am new to Qlikview.
How to calculate past 3 months total sales in strightable for each month.
Month | Sales |
---|---|
Dec | 5000 |
Jan | 200 |
Feb | 700 |
Mar | 300 |
Apr | 400 |
Thanks & Regards
Swathi
You have to order the dimension correctly first.
This will work after you sort:
RangeSum (
Above (Sum(Sales) , 0 , 3)
)
If I mention total in front of sum is working. may I know the reason for this?
rangesum(above(total sum(Amount),0,3))