Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hide previous months when accumulating dates

I've created a run chart that is accumulting 10-steps (months) back. In the chart display, I would like to hide the months that are not fully accumulated as they are just a sloped line. Any advice would be greatly appreciated. Thanks ahead of time.

-Brian

1 Reply
johnw
Champion III
Champion III

This isn't quite what you're asking for, but for a rolling 10 month average, for example, you could get an average of the months so far for the first 9 months. Rather than doing the accumulation, do this:

rangeavg(above(Amount,0,10))

That says you want the average of the current row and the nine rows above it. For the first nine months, it will only average the rows it can find.

Unfortunately, I haven't thought of how to actually exclude the first nine rows since they're used in the accumulation.