topic Re: How to remove or hide row with null or missing value in straight table expression in Qlikview ? in QlikView

How to remove or hide row with null or missing value in straight table expression in Qlikview ?

sona_sa — Mon, 04 Mar 2019 17:56:37 GMT

Hi Team, Please find the attached QVW, I want to hide my Null Value ROW from the Staright Table Expression. Please help me on this, I tried by using Len, Variable. But I could not able to hide or remove the rows, which has null,0 or missing value in my expression. Thanks & Regards, AS

Re: How to remove or hide row with null or missing value in straight table expression in Qlikview ?

bharathadde — Mon, 04 Mar 2019 18:23:46 GMT

Please check the attachment, you will find the solution.

Re: How to remove or hide row with null or missing value in straight table expression in Qlikview ?

sona_sa — Mon, 04 Mar 2019 18:46:05 GMT

Hi Bharat,

Please find the attached QVW. In this format, Output is coming. Now Where RGB Null Value is available, That row wanna hide or remove from straight table.

Please help me on this. Please find the attached QVW.

Re: How to remove or hide row with null or missing value in straight table expression in Qlikview ?

sona_sa — Mon, 04 Mar 2019 18:58:12 GMT

Also I can not make the same calculation in script, Whatever I have to do, Only from GUI Part. At object level. So If it is possible make it possible from GUI Level.

Regards,

Re: How to remove or hide row with null or missing value in straight table expression in Qlikview ?

sona_sa — Tue, 05 Mar 2019 01:36:45 GMT

Hi Team,

Anyone can help me on the same. I want to remove or hide where is null, 0 or Missing value is available in my Expression.

Need the solution from GUI part, Not want to write a code or change the script.

For ref. please find the attached QVW.

Regards,