Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JoannaM
Contributor III
Contributor III

Replace '-' (blank) with 0

Hi all

I want to replace the blank cells in my pivot table with 0. I think I tried everything...

I am loading the data on a daily basis but sometimes there is no value for a material corresponding to a date.

Hence the '-' (blank) cells. I want to change the blanks to zeros.

JoannaM_0-1640166841558.png

Thanks for any input. Best regards, Joanna

1 Reply
Or
MVP
MVP

If you run a quick search, you'll find this gets asked a fair bit... if the nulls are a result of missing vales, you can fill in the missing values in your data load. Otherwise, you're out of luck (with the native pivot; some extensions may have ways around this - I believe Vizlib Pivot has the option to select what the null indicator is).

e.g. https://community.qlik.com/t5/New-to-Qlik-Sense/Use-zero-instead-of-null-in-pivot-table/td-p/1746316

See:

https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394