How to handle Null and Zero in pivot

New-Qlik — Fri, 02 Apr 2021 07:58:01 GMT

Hello,

I have a table which have null values and zero. I want to eliminate rows for which measure is null for all .

please see below example

output is coming like this when I uncheck include zero values . Zero are getting replace with '-.'

Zero is value so cant be changed to -

It should look like

Re: How to handle Null and Zero in pivot

rahulsud007 — Mon, 17 Jun 2019 10:49:31 GMT

In the expression editor use, if(isnull(expression),0,expression)