Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Blank field instead of zero values in pivot chart

Hi everyone,

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

Tnx

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

5 Replies
Anonymous
Not applicable
Author

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))

Not applicable
Author

Tnx for fast reply

Anonymous
Not applicable
Author


you are welcome!

Not applicable
Author

HI,

I want to Suppress the Blank Reccords also...

HOw Can I Acheive this ...

Regards,

Helen

sskinner
Contributor II
Contributor II

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.