Pivot Null Values

[sat_tok52]

Hi Guru's,

We are using pivot table it has null or missing value how can I handle that.When null values in pivot it will convert to zero dynamically.

I Replaced Missing symbols to zero in presentation  tab it's working fine but I need same by expression.

Thanks,

Sateesh

[Chanty4u]

NULL values in the Pivot Table

chk abve

[sunny_talwar]

One way to convert Null to 0 is by using Alt function. But I think this is possible for Nulls and not missing. But you can definitely give it a shot:

Alt(YourExpression, 0)

[avinashelite]

you can check for the null values in the script and assign a flag for the same . Then in the set analysis use this flag ...this would help you to show the null values using the expression

[Anonymous]

might help you?

NULL handling in QlikView

Handling NULL in a simple report

how to handle null values in qlikview | Qlik Community