Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
go to properties and uncheck "suppress zero-values"
Thank you, I really do feel dumb now...