topic Re: rangesum expression in QlikView

rangesum expression

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I have a requirement like below

My user wants to selects any month ,it should sum the selected month data and previous months data.

Suppose user selects July month it should display sum (July + all previous months) sales

If he selects November it should display sum ( Nov sales + previous months) sales......and so on......

For this I have used expression like rangesum(above(total sum(sales),0,3))----It will evaluate only 3 months(3 is hard coded) sales.

Which function we should use if user makes dynamic month selections.

Thanks in advance

venkatg6759 — Tue, 10 Jun 2014 17:39:45 GMT

rangesum(above(total sum(sales),0,Rowno(TOTAL)))

Anonymous — Tue, 10 Jun 2014 17:44:38 GMT

You use set anlysis instead of rangesum() in this case. That is, if month is dual, someting like:

sum({<Month={"$(='<=' &num(Month))"}, Year=P(Year) >} Sales