Solved: Blank field instead of zero values in pivot chart - Qlik Community

Report Inappropriate Content · ‎2014-03-26

Hi everyone,

I want to set blank values in field insted of zero values in pivot chart. How to achieve this?

Tnx

Anonymous · ‎2014-03-26

if the zeroes are a result of an expression, then try something like (replace sum(Product) with your expression)

if(sum(Product)=0,'',sum(Product))

View solution in original post

Anonymous · ‎2014-03-26

if the zeroes are a result of an expression, then try something like (replace sum(Product) with your expression)

if(sum(Product)=0,'',sum(Product))

Report Inappropriate Content · ‎2014-03-26

Tnx for fast reply

Anonymous · ‎2014-03-26

you are welcome!

Report Inappropriate Content · ‎2014-10-13

HI,

I want to Suppress the Blank Reccords also...

HOw Can I Acheive this ...

Regards,

Helen

sskinner · ‎2018-09-25

Seems messing with the expression is a awkward solution. The "Number" tab on expressions allows you to set a format pattern (e.g. #,##0), so you would think #,### would work to suppress the zero - but it does not (bug?). As an alternate solution, if you do not have negative values, you can use the "Visual Cues" tab to hide a zero value with a white color or 100% transparency.