Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Highlighted
avneet85
Contributor

How to handle Null and Zero in pivot

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

NameIdEnergyProteinVit DVit B
Egg112.31.20.80
Apple12-101.1
Pear13----
Milk142.1000

 

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

Zero is value so cant be changed to -

      
NameIdEnergyProteinVit DVit B
Egg112.31.20.8-
Apple12     -1-1.1
Milk142.1---

 

It should look like

NameIdEnergyProtienVit DVit B
Egg112.31.20.80
Apple12     -101.1
Milk142.1000
1 Reply
rahulsud007
Contributor

Re: How to handle Null and Zero in pivot

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