Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

Pivot Null Values

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

4 Replies
Chanty4u
MVP
MVP

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