topic Re: Accumulate Sum only until current month in QlikView

Accumulate Sum only until current month

divya_anand — Sat, 16 Nov 2024 21:29:29 GMT

Hi,

In the below screenshot, I have 2 expressions - the blue line is for the selected year ( in this case 2019 is selected) and the red line is for the previous year (selected year - 1). As you can see, in 2019 we have data only until current month, but the accumulation is done for until Dec. How can I show accumulation only until current month if the current year is selected? I have attached a sample QVW for reference.

Thank you.

Re: Accumulate Sum only until current month

madhu_r — Fri, 01 Feb 2019 07:38:10 GMT

Hi,

Try this

In Expression for only(Year) give this expression: Rangesum(Above(Sum(Sales),0,Max(Month)))

Re: Accumulate Sum only until current month

adamgaox — Fri, 01 Feb 2019 07:53:52 GMT

Try this in the 2018 expression

Rangesum(Above(Sum({<Year={$(=Only(Year)-1)},Month = {$(=Concat(DISTINCT chr(39) & Month & Chr(39),','))}>}Sales),0,RowNo()))

Re: Accumulate Sum only until current month

sunny_talwar — Fri, 01 Feb 2019 12:51:26 GMT

You can also use these expression if there are no 0 sales for any particular month in the past

Year

=If(Sum(Sales) > 0, Rangesum(Above(Sum(Sales),0,RowNo())))

Previous Year

If(Sum({<Year={$(=Only(Year)-1)}>}Sales) > 0, Rangesum(Above(Sum({<Year={$(=Only(Year)-1)}>}Sales),0,RowNo())))