Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graph Axes minimum

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?


Thanks

Ian

Zero.bmpRequired.bmp

1 Solution

Accepted Solutions
cesaraccardi
Specialist
Specialist

Please take a look, I made a verification for the first expression ensuring it wont return 0 values.

Regards,

Cesar

View solution in original post

9 Replies
cesaraccardi
Specialist
Specialist

Hi Ian,

You can uncheck the option "Forced 0" for all of your expressions in the "Axes" tab of the chart.

Regards,

Cesar

Not applicable
Author

Already done Cesar, but no effect. Axes still show from zero

Ian

cesaraccardi
Specialist
Specialist

Have you tried with the "Supress Zero-Values" option at Presentation tab checked?

Not applicable
Author

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!

cesaraccardi
Specialist
Specialist

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?

cesaraccardi
Specialist
Specialist

Another important thing is that the option Forced 0 must be unchecked for each expressions you have individually.

Not applicable
Author

QVW now attached Cesar.


Thanks

Ian

MayilVahanan

HI

     Is not start with zero... Its start with one only.

    

     Please see the attached file.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
cesaraccardi
Specialist
Specialist

Please take a look, I made a verification for the first expression ensuring it wont return 0 values.

Regards,

Cesar