Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
jsaradhi
Specialist
Specialist

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
jsaradhi
Specialist
Specialist

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

Not applicable
Author

Tnx for fast reply

jsaradhi
Specialist
Specialist


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.