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

[sona_sa]

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

[bharathadde]

Please check the attachment, you will find the solution.

[sona_sa]

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.

[sona_sa]

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,

AS

[sona_sa]

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,

AS