help me to wirite set expression

[Anonymous]

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

[vkish16161]

You have to order the dimension correctly first.

This will work after you sort:

RangeSum (

Above (Sum(Sales) , 0 , 3)

)

[maxgro · Accepted solution]

this can help

Calculating rolling n-period totals, averages o... | Qlik Community

[Anonymous]

If I mention total in front of sum is working. may I know the reason for this?

rangesum(above(total sum(Amount),0,3))