Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sateeshkumar
Creator
Creator

straight table to display zeroes but not nulls

Hi,

I have requirement to show detail report in Straight table. And i written expressions as below.

Expression: if(Expr1>=$(user_input_value), Expr1, null())

Here user_input_value will be provided by user by using input box. so if my expression values greater than that variable it has to display else hide that row. So i used above condition and kept 'Suppress zero values' in presentation tab. So it is working fine. but my problem is if my actual expression value is 0 then also it is suppressing the row. I dont want to suppress those. So please some one help to show expression even zeros present but not null values.

Regards

Sateesh

2 Replies
marcus_sommer

There is an option for it within the object properties in tab presentation.

- Marcus

sateeshkumar
Creator
Creator
Author

Thanks for your reply Marcus, could you please tell me what is that property in presentation tab. I have checked all the properties like 'Suppress missing'  and 'suppress zero values', but that is not working