Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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