Discussion board where members can get started with QlikView.
I'm new to Qlikview.
I have the following expression:
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%'
If(QTYONHND_3 <=0, 'YES', 'NO')
Does return my zeros as below in line 5
My average percentage willbe out unless they are included.
go to properties and uncheck "suppress zero-values"
View solution in original post
Thank you, I really do feel dumb now...