Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
1 Reply
Highlighted
Creator
Creator

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