How to handle Null and Zero in pivot

[New-Qlik]

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

Name	Id	Energy	Protein	Vit D	Vit B
Egg	11	2.3	1.2	0.8	0
Apple	12	-	1	0	1.1
Pear	13	-	-	-	-
Milk	14	2.1	0	0	0

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

Zero is value so cant be changed to -

Name	Id	Energy	Protein	Vit D	Vit B
Egg	11	2.3	1.2	0.8	-
Apple	12	-	1	-	1.1
Milk	14	2.1	-	-	-

It should look like

Name	Id	Energy	Protien	Vit D	Vit B
Egg	11	2.3	1.2	0.8	0
Apple	12	-	1	0	1.1
Milk	14	2.1	0	0	0

[rahulsud007]

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