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: 
waqasshah
Creator
Creator

Zero value in Chart

Hi All,

I am developing a dashboard and I am facing a problem to display zero value in charts. My expression value is giving me correct results between the dates but the values appear on chart like from April 2016 until oct 2016 as zero (0).

which I don't want to display . I just want to display the values between November 2016 and October 2017.

Please review the attached screenshots.

Kind Regards

Waqas Shah

16 Replies
YoussefBelloum
Champion
Champion

Hi, try to attach your app or sample data

sunny_talwar

Check to make sure that 'Suppress Zero Value' is checked on the presentation tab

waqasshah
Creator
Creator
Author

sorry its a very huge file...do I need to fix it in the sql sever ?

waqasshah
Creator
Creator
Author

The issue is If I click an option 'Suppress Zero Value' then I am not able to view zero values in chart

sunny_talwar

Then may be give a really small number for the 0s you want to show like 0.0000000001 and 0s for the places which you don't want to show and then check 'Suppress Zero Values'. This will keep 0.0000000001, but get rid of 0s

waqasshah
Creator
Creator
Author

Thanks but issue is the values before November I don't want to display. I want to restrict them? How can I do that in expression or else where?

sunny_talwar

Should be done in the expression... can you share a sample to test?

sunny_talwar

Would you be able to share qvw or qvf sample?

waqasshah
Creator
Creator
Author

its a very big file......