Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

swathi_muthuru
New Contributor III

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

Accepted Solutions
MVP
MVP

Re: help me to wirite set expression

3 Replies
vkish16161
Contributor III

Re: help me to wirite set expression

You have to order the dimension correctly first.

This will work after you sort:

RangeSum (

Above (Sum(Sales) , 0 , 3)

)

MVP
MVP

Re: help me to wirite set expression

swathi_muthuru
New Contributor III

Re: help me to wirite set expression

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

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