topic Need to remove row having blank column in QlikView

Need to remove row having blank column

Fri, 15 Jul 2011 10:08:17 GMT

I have a large table having many columns. For example I have shown only below columns.

Suppose I want below columns but data should not include the third row from above table as Custome ID is missing.

what should be my code?

kaushiknsolanki — Fri, 15 Jul 2011 10:11:13 GMT

HI,

Go to peoperties of chart.

In dimension tab -> Click on the dimension Custoer_ID -> at bottom you will see an checkbox named Suppress when value is Null.

Click on it.

Regards,

Kaushik Solanki

Fri, 15 Jul 2011 10:35:09 GMT

Thanks .... working...

pgalvezt — Thu, 18 Aug 2011 19:12:04 GMT

How can I remove the same column but into my expression formula?

Wed, 11 Feb 2015 12:16:37 GMT

Thanks Kaushik Solanki ..