Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide empty dimensions on trend graph (QV10)

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

)

0 Replies