topic Re: Show zero value but not fields with no value in App Development

Show zero value but not fields with no value

Qlik_Benjamin — Wed, 16 Aug 2023 09:40:56 GMT

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 — Wed, 16 Aug 2023 14:15:01 GMT

Hey,

Try using this expression once

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

Thanks,

Saloni

Qlik_Benjamin — Tue, 19 Sep 2023 11:28:34 GMT

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