Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

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
Labels (1)
1 Reply
rahulsud007
Creator
Creator

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