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: 
mikepitcher
Contributor
Contributor

Missing Zero Values

Hi,

I'm new to Qlikview.

I have the following expression:

if(QTYONHND_3/ORDERPNTQTY_3>=1,1,QTYONHND_3/ORDERPNTQTY_3)

This works ok and gives me the following

clipboard_image_0.png

But it is suppressing any line for when QTYONHND_3 = Zero, where I would like to return '0%'

Where as 

If(QTYONHND_3 <=0, 'YES', 'NO')

Does return my zeros as below in line 5

clipboard_image_1.png

My average percentage willbe out unless they are included.

 

Please help.

Thanks.

1 Solution

Accepted Solutions
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

go to properties and uncheck "suppress zero-values"

View solution in original post

2 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

go to properties and uncheck "suppress zero-values"

mikepitcher
Contributor
Contributor
Author

Thank you, I really do feel dumb now...