topic Remove or Hide the Null or Missing value's Row from Straight Table Expression. in QlikView

Remove or Hide the Null or Missing value's Row from Straight Table Expression.

sona_sa — Tue, 05 Mar 2019 01:41:09 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. In this QVW there is no any null or missing value is available in Dimension.

For ref. please find the attached QVW.

Regards,

Re: Remove or Hide the Null or Missing value's Row from Straight Table Expression.

hopkinsc — Wed, 06 Mar 2019 17:18:25 GMT

There is probably a much better solution out there but the rows are showing because there is a value in the first expression.

so a dirty work around is to put the condition that you have in the 2nd expression in the first too like the attached.

Re: Remove or Hide the Null or Missing value's Row from Straight Table Expression.

Claudiu_Anghelescu — Wed, 06 Mar 2019 17:19:41 GMT

See the buttons

Re: Remove or Hide the Null or Missing value's Row from Straight Table Expression.

hopkinsc — Wed, 06 Mar 2019 17:23:13 GMT

I said there would be an easier solution! 🙂 obviously you would have to add in any other values into the select in field within the actions on the button