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

[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. In this QVW there is no any null or missing value is available in Dimension.

For ref. please find the attached QVW.

Regards,

AS

[hopkinsc]

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. 

[Claudiu_Anghelescu]

See the buttons

[hopkinsc]

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