Show zero value but not fields with no value

[Qlik_Benjamin]

Hi all,

I would like to show in a bar chart the zero value as displayed on top but not the values that have no value (-). See image attached.

Any ideas or more information necessary?

Many thanks and best,

Benjamin

[salonicdk28]

Hey,

Try using this expression once

If( NumericCount(Field), Sum(Field), NULL()) 

Thanks,

Saloni

[Qlik_Benjamin · Accepted solution]

Solution (Workaround!) is to import the zero values, replace them with 0,0001 and only show two digits after the comma.

Everything else did not work for me.

Thanks