topic Re: Pivot Null Values in QlikView

Pivot Null Values

sat_tok52 — Sat, 27 Feb 2016 04:33:22 GMT

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

Re: Pivot Null Values

Chanty4u — Sat, 27 Feb 2016 07:05:39 GMT

NULL values in the Pivot Table

chk abve

Re: Pivot Null Values

sunny_talwar — Sat, 27 Feb 2016 11:07:51 GMT

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)

Re: Pivot Null Values

avinashelite — Mon, 29 Feb 2016 07:43:46 GMT

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

Re: Pivot Null Values

Anonymous — Mon, 29 Feb 2016 07:47:06 GMT

might help you?

NULL handling in QlikView

Handling NULL in a simple report

how to handle null values in qlikview | Qlik Community