topic Re: Zero value in Chart in QlikView

Zero value in Chart

waqasshah — Tue, 21 Nov 2017 12:54:01 GMT

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

Re: Zero value in Chart

YoussefBelloum — Tue, 21 Nov 2017 13:10:23 GMT

Hi, try to attach your app or sample data

Re: Zero value in Chart

sunny_talwar — Tue, 21 Nov 2017 13:12:20 GMT

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

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 13:12:25 GMT

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

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 13:14:02 GMT

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

sunny_talwar — Tue, 21 Nov 2017 13:16:06 GMT

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

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 13:46:59 GMT

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

sunny_talwar — Tue, 21 Nov 2017 13:49:57 GMT

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

Re: Zero value in Chart

sunny_talwar — Tue, 21 Nov 2017 14:28:43 GMT

Would you be able to share qvw or qvf sample?

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 14:32:52 GMT

its a very big file......

Re: Zero value in Chart

sunny_talwar — Tue, 21 Nov 2017 14:34:08 GMT

If it is a qvw, look here to reduce the size

Preparing examples for Upload - Reduction and Data Scrambling

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 14:41:41 GMT

yeah .. but this issue is how you can access the db file ??? or you just need the structure ?

Re: Zero value in Chart

sunny_talwar — Tue, 21 Nov 2017 15:07:48 GMT

Do you have a qlikview file you work with? Can you trim down the data using some selections and share it?

Preparing examples for Upload - Reduction and Data Scrambling‌

Also, from the data you share, explain what is the issue that you are facing? What is that you expect to see instead?

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 15:14:28 GMT

Thanks sunny for helping me. The issue is I want to display the value 0 (Zero) in my chart from my expression that giving results from Nov 2016 until October 2017.

But when I uncheck the option suppress zero-values it is showing me data before nov 2016..

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 15:15:57 GMT

I want the attached output... no data before nov 2016...

Re: Zero value in Chart

sunny_talwar — Tue, 21 Nov 2017 15:18:47 GMT

Sorry, I have no way I will be able to help. But I am sure someone else have better idea

Best,

Sunny

Re: Zero value in Chart

waqasshah — Tue, 21 Nov 2017 15:19:47 GMT

Thanks Sunny. no problem