Discussion board where members can get started with QlikView.
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?
Go to Solution.
Please take a look, I made a verification for the first expression ensuring it wont return 0 values.
You can uncheck the option "Forced 0" for all of your expressions in the "Axes" tab of the chart.
Already done Cesar, but no effect. Axes still show from zero
Have you tried with the "Supress Zero-Values" option at Presentation tab checked?
Yes, with the box unticked you can clearly see the line hitting zero in the later months, with the box ticked, the line is hidden bu the graph axis remains the same.
Thanks for trying!
I understand... When you uncheck the Forced 0 option it will start from the minimum value you have, if you have 0 values for some dimensions you need to supress these values. Can you post your qvw or a sample?
Another important thing is that the option Forced 0 must be unchecked for each expressions you have individually.
QVW now attached Cesar.
Is not start with zero... Its start with one only.
Please see the attached file.