Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

waqasshah
Contributor

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
Esteemed Contributor

Re: Zero value in Chart

Hi, try to attach your app or sample data

Re: Zero value in Chart

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

waqasshah
Contributor

Re: Zero value in Chart

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

waqasshah
Contributor

Re: Zero value in Chart

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

Re: Zero value in Chart

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
Contributor

Re: Zero value in Chart

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?

Re: Zero value in Chart

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

Highlighted

Re: Zero value in Chart

Would you be able to share qvw or qvf sample?

waqasshah
Contributor

Re: Zero value in Chart

its a very big file......

Community Browser