topic Remove tail in Rolling R1/R12 chart in QlikView

Remove tail in Rolling R1/R12 chart

tseebach — Tue, 16 Feb 2010 10:34:01 GMT

Hi,

I got a rolling months average, and I need some way to cut of the tails of the charts, see the image, the part outside the bar charts areas.

The formula for the green line is this:

(rangeavg(above(sum({$<KEY_ACCNO = {'1600'},Date = {">=$(=(MonthStart(AddMonths(Max(ALL [Date]),-40)))) "},Calender.Year= ,Calender.MonthName= >} $(=ValueFieldAcc)),0,13))*360)
/
rangesum(above(sum({$<KEY_ACCNO = {'80100'},Date = {">=$(=(MonthStart(AddMonths(Max(ALL [Date]),-40)))) "},Calender.Year= ,Calender.MonthName= >} -$(=ValueField)),0,12))

I've tried putting a If around to remove the dates which are not within 36 months. Any ideas?

Remove tail in Rolling R1/R12 chart

Tue, 16 Feb 2010 12:51:28 GMT

Hi Torben,

Could you attach a file like example. It'll help us for finding a solution quickly.

Best regards.

Remove tail in Rolling R1/R12 chart

tseebach — Tue, 16 Feb 2010 14:41:02 GMT

Yep,

I've reproduced the issue in this example:

http://dl.dropbox.com/u/1773255/testRollingR12.qvw

Remove tail in Rolling R1/R12 chart

tseebach — Tue, 16 Feb 2010 14:41:17 GMT

Yep,

I've reproduced the issue in this example:

http://dl.dropbox.com/u/1773255/testRollingR12.qvw