Exclude row if one column value is null

[babud41]

Hi all

How to exclude a row in a straight table where one of the column (open_gart) value is null.

I will attach a pic for reference.

Thanks in advance

Dinesh

QlikView 

[abhijitnalekar]

Hi @babud41 ,

We can uncheck the include null values for the dimension. but in your scenario, we have to go with a workaround and need to create a new dimension base on the measure and we can exclude null for that.

Can you please share the sample data?