Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi,

go to properties and uncheck "suppress zero-values"

View solution in original post

2 Replies
Highlighted
Partner
Partner

Hi,

go to properties and uncheck "suppress zero-values"

View solution in original post

Highlighted
Contributor
Contributor

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