Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need to remove row having blank column

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

Customer IDInvoice NumberPart Number
CID 001A0023ABC123
CID 002A0024ABC456
A0025DEF123
CID 003A0026DEF456

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?

Customer IDInvoice NumberPart Number
CID 001A0023ABC123
CID 002A0024ABC456
CID 003A0026DEF456
1 Solution

Accepted Solutions

Need to remove row having blank column

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

4 Replies

Need to remove row having blank column

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

Not applicable

Need to remove row having blank column

Thanks .... working...

pgalvezt
Valued Contributor

Need to remove row having blank column

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

Not applicable

Re: Need to remove row having blank column

Thanks Kaushik Solanki ..