Do not show Dimension containing

[Anonymous]

Hi all,

Just started with Qlikview personnel,

I have a straight table (below) In the description i do not want the positions containing the word door to be shown or counted, how do i do this?

[laxmanqlik]

Sunny can you help me avoid null values in bar chart