Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table Query

Hi,

In a Pivot table... wherever there is a zero I want to replace it with blank.

Is it possible and if yes then how??

Regards

2 Replies
Not applicable
Author

Hi Rohita,

This is possible. If you want to replace zeros by a null(blank spaces are known as null), you just need to write a chart expression. The expression is like this.

if(field=0,' ',fieldvalue)

in this expression field represents that field which you want to check where there are any 0's in it. if you give this expression in your chart then I hope your problem will be solved. hope this helps you...

Thanks and regards

Joseph

Not applicable
Author

Thanks a lot Joseph 🙂

It worked!!