topic Re: How to suppress zero values in QS waterfall chart in App Development

How to suppress zero values in QS waterfall chart

mgmqlik123 — Sat, 16 Nov 2024 01:20:07 GMT

Hi,

Please let me know if we can suppress zero values in qlik sense waterfall chart. Please find the attachment for your reference.

Thanks

Re: How to suppress zero values in QS waterfall chart

avinashelite — Tue, 06 Oct 2020 07:40:04 GMT

*Make sure you have not enabled show all values in the dimensions

*If the above is not the case handle in the expression like this

if(expression >0, expression ,null()) then enable suppress null values

Re: How to suppress zero values in QS waterfall chart

Usama — Tue, 06 Oct 2020 08:01:09 GMT

Hi,

These 0 values present in your data. You can make it as 'Null'. For this you can try following in measure:
If(Sum(measure)=0,'Null',Sum(measure))
Sum(measure)= Whatever measure you are using.

Thanks

Re: How to suppress zero values in QS waterfall chart

mgmqlik123 — Wed, 07 Oct 2020 09:35:05 GMT

Hi Both,

Thanks for your reply.

I tried your suggestions. It works fine in individual expression. But, when I try to apply the same in waterfall chart still I can see the 0 bar.. 😞