Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sateeshkumar
Contributor

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
MVP & Luminary
MVP & Luminary

Re: straight table to display zeroes but not nulls

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

- Marcus

sateeshkumar
Contributor

Re: straight table to display zeroes but not nulls

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