Discussion Board for collaboration on QlikView Scripting.
Hi I am new to Qlikview.
How to calculate past 3 months total sales in strightable for each month.
Thanks & Regards
Go to Solution.
this can help
Calculating rolling n-period totals, averages o... | Qlik Community
You have to order the dimension correctly first.
This will work after you sort:
Above (Sum(Sales) , 0 , 3)
If I mention total in front of sum is working. may I know the reason for this?