Missing Zero Values

[mikepitcher]

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

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

My average percentage willbe out unless they are included.

Please help.

Thanks.

[StarinieriG · Accepted solution]

Hi,

go to properties and uncheck "suppress zero-values"

[mikepitcher]

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