Replace '-' (blank) with 0

[JoannaM]

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.

Thanks for any input. Best regards, Joanna

[Or]

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