topic Re: Suppress rows/nulls in qlik sense in App Development

Suppress rows/nulls in qlik sense

Vinn_Qlik — Sun, 31 May 2020 03:31:17 GMT

I have a requirement like - there is one field which has three values

Field Name : Status

Values : Plan,confirm,close

Now I dont want to load volumes associated to 'close'. Hence, I restricted while loading into <>close .

But the values associated to 'Close' status in UI straight table are still coming up,value under field Status showing as '-'(Close status one's).

When I try to suppress NULLS in UI, it is supressing other Nulls as well. I dont want to supress all the nulls but I want to supress only records associated to Close status.

Can anybody help me pls.Thanks in advance.

Re: Suppress rows/nulls in qlik sense

Madhur — Mon, 01 Jun 2020 00:30:48 GMT

Hi @Vinn_Qlik

If you are putting a filter in the where clause of the load statement then complete row will not be loaded in the table where status = 'close'. I believe that 'volumes ' is present in other table and it is not able to find the associated status. So you have to handle that.

Re: Suppress rows/nulls in qlik sense

Vinn_Qlik — Mon, 01 Jun 2020 10:59:03 GMT

Hi @Madhur ,

Thanks for the response.

Yes, volumes are from different multiple tables not from the status table. Could you pls suggest me or share your thoughts on how to handle the associated values, I have been trying multiple ways but couldnt fix it. Appreciate if you share inputs.

Regards,

Ravi

Re: Suppress rows/nulls in qlik sense

Madhur — Tue, 02 Jun 2020 02:26:17 GMT

Hi @Vinn_Qlik ,

What you can try is apply filter -> "where Status <> 'close' "in the table containing status description, and apply filter "where Exists(%StatusID)" on all the tables from where 'value' details are flowing. '%StatusID' is the key column used for association between table. If it is still not working please share the qvs or qvf .

Re: Suppress rows/nulls in qlik sense

Vinn_Qlik — Sat, 06 Jun 2020 03:25:05 GMT

Hi @Madhur

Thanks for sharing your valuable inputs. much appreciated.

Now, data has been restricted at the Date ware house and no action is required from Qlik end. Thanks once again.

Regards,

Ravi