Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

geogou1973
New Contributor III

How can i display zero values in a chart

Hello.

I have a problem in a chart that not appears the zero values.

I have a table that with items and qty. Some qty are zero.

When i create a table all the items appears in it but when i create a chart suppress all the items that have qty zero.

Can someone tell me what i can do in order to display all the items ?

Thank you in advance.

1 Solution

Accepted Solutions

Re: How can i display zero values in a chart

Hi gou, in presentation tab, try to uncheck "supress zero values"

View solution in original post

5 Replies

Re: How can i display zero values in a chart

Try this in your expression:

If( yourExpression = 0, 0.00000001, yourExpression)

Let me know if it works.

Best,

S

Re: How can i display zero values in a chart

Hi gou, in presentation tab, try to uncheck "supress zero values"

View solution in original post

Not applicable

Re: How can i display zero values in a chart

Hi

in chart properties / presentation tab / untick Suppress Zero Values

best regards

neetha_p
Honored Contributor

Re: How can i display zero values in a chart

Hi,

Go To Chart Properties - Presentation tab - Uncheck Suppress Zero-values checkbox

Regards

Neetha

agomes1971
Valued Contributor II

Re: How can i display zero values in a chart

Hi,

at the Chart Properties in the Expression Axes tab take a closer look if Forced 0 is checked...

Regards

André Gomes