Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Thanks .... working...

pgalvezt
Specialist
Specialist

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

Not applicable
Author

Thanks Kaushik Solanki ..