How to suppress zero values in QS waterfall chart

[mgmqlik123]

Hi,

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

Thanks

[avinashelite]

*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 

[Usama]

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

[mgmqlik123]

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.. 😞