topic Exclude row if one column value is null in QlikView

Exclude row if one column value is null

babud41 — Mon, 26 Jan 2026 16:26:21 GMT

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

Re: Exclude row if one column value is null

abhijitnalekar — Mon, 18 Oct 2021 08:35:18 GMT

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?