Missing Zero Values

mikepitcher — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Missing Zero Values

StarinieriG — Tue, 08 Oct 2019 09:34:09 GMT

Hi,

go to properties and uncheck "suppress zero-values"

mikepitcher — Tue, 08 Oct 2019 09:37:34 GMT

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