Set Null Values to 0 Pivottable

[SonPhan]

Hello guys,

is it possible to change Null Values in a pivot table to 0?

Thank you!

Best regards 

Son

[Chanty4u]

Hi,

you can try this method.

https://community.qlik.com/t5/New-to-Qlik-Sense/show-quot-nothing-quot-as-Zeros-in-Pivot-table/td-p/...

or

rangesum(yourfield,0) as yourfield