Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

help me to wirite set expression

Hi I am new to Qlikview.

How to calculate past 3 months total sales in strightable for each month.

MonthSales
Dec5000
Jan200
Feb700
Mar300
Apr400

Thanks & Regards

Swathi

1 Solution
3 Replies
vkish16161
Creator III
Creator III

You have to order the dimension correctly first.

This will work after you sort:

RangeSum (

Above (Sum(Sales) , 0 , 3)

)

Anonymous
Not applicable
Author

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

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