Hide previous months when accumulating dates

Anonymous — Wed, 24 Jun 2009 23:15:56 GMT

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

Hide previous months when accumulating dates

johnw — Fri, 26 Jun 2009 03:20:46 GMT

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.

topic Hide previous months when accumulating dates in QlikView

Hide previous months when accumulating dates

Hide previous months when accumulating dates