Hide empty dimensions on trend graph (QV10)

Thu, 07 Jun 2012 13:19:00 GMT

I have set up a trend graph with an expression that calculates a rolling-12 month average, using the formula below. The earliest [Incurred Year Month] 200801. Because you need full 24 months before the expression makes sense, any incurred year month before 200912 is blank, but each blank month still appears on the x-axis.

My goal is to make it so that months 200801 thru 200911 do not even show up on the chart, since it takes up a lot of space. In other words, the left-most date is 200912. Is there any way to cut off these values from the chart?

=if([Incurred Year Month]<200912,'',

rangesum(above(sum([Sales]),0,12))

rangesum(above(sum([Sales]),12,12)) -1

)

topic Hide empty dimensions on trend graph (QV10) in QlikView

Hide empty dimensions on trend graph (QV10)