This content has been marked as final. Show 9 replies
I have a single table within a QVW file with (amongst others) 3 columns for 10/11 Activity, 11/12 Activity and 12/13 Activity.
When graphing this to compare year on year activity levels, the axis of the graph always starts at zero as months 6-12 of 12/13 Activity are null/zero.
Is there a way of getting QV to ignore nulls/zeros so I can get the graph on the right?
I have tried using static min but of course once filters are applied, this min value causes data not to be viewed?