topic Re: Hide empty records in QlikView

Hide empty records

Luke_Killer_IT — Mon, 11 Apr 2022 09:13:37 GMT

Hello, I have this problem I need to hide empty records I created this command

if(Sum(MMT_MRPAccount.DemandQty)>0 ,Sum(MMT_MRPAccount.DemandQty),' ')

Re: Hide empty records

anat — Mon, 11 Apr 2022 10:48:06 GMT

click on "Suppress when value is null"

Re: Hide empty records

Luke_Killer_IT — Mon, 11 Apr 2022 12:23:17 GMT

I am not using imported data in this table, I am using chart functions and therefore I have problems with hiding unwanted empty data.

Re: Hide empty records

anat — Mon, 11 Apr 2022 12:24:51 GMT

go to presentation tab ,suppress null value

Re: Hide empty records

Prasad_Kanse — Tue, 12 Apr 2022 11:26:52 GMT

1) dimension Tab > Suppress When value is Null

2) Presentation Tab > Suppress Zero - Values

But as I can see you are using multiple expressions. Other expressions giving you the extra rows in a result. So, you have to use set analysis expression for Bedaft i.e. {< Field_name = {" sum(expression) >1 "} > }.

Re: Hide empty records

Anonymous — Tue, 12 Apr 2022 15:42:14 GMT

Perhaps changing the expression to:

if(sum(MMT_MRPAccount.DemandQty) >0, sum(MMT_MRPAccount.DemandQty), Null() )

and then as others suggested change the setting to suppress null values.

With your current expression the 0 or less values are a string of spaces and are not nulls.

HTH,

John