Zero value in Chart

[waqasshah]

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

[YoussefBelloum]

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]

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

[waqasshah]

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]

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]

its a very big file......