Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
Hi gou, in presentation tab, try to uncheck "supress zero values"
View solution in original post
Try this in your expression:
If( yourExpression = 0, 0.00000001, yourExpression)
Let me know if it works.
in chart properties / presentation tab / untick Suppress Zero Values
Go To Chart Properties - Presentation tab - Uncheck Suppress Zero-values checkbox
at the Chart Properties in the Expression Axes tab take a closer look if Forced 0 is checked...