topic Re: straight table to display zeroes but not nulls in QlikView

straight table to display zeroes but not nulls

sateeshkumar — Thu, 23 Nov 2017 15:13:39 GMT

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

Re: straight table to display zeroes but not nulls

marcus_sommer — Thu, 23 Nov 2017 15:32:19 GMT

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

- Marcus

Re: straight table to display zeroes but not nulls

sateeshkumar — Thu, 23 Nov 2017 15:43:46 GMT

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