Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

If a Column is blank in a Table box can I supress/hide the column within that table box?

Hello, I have a list box that has an X as a column indicators, see table below...

ID          Color          Stone     Red          White

1            Red           Ruby        x                     

2            Red           Ruby       x                

based on my selection from my list box the X indicators change from Red, white ect. Is there a way to hide a column if there not a value or if the column is blank? What I would like to see

  

ID         Color         Stone    Red      

1            Red          Ruby      x                    

2            Red          Ruby      x    

    

I have the below but it just clears the label and the column still displays. Thoughts?

=

IF([White] ='',null(),[White])

Message was edited by: John mingus

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Hi,

You don't have much flexibility with Table box, you can go for Straight table where you can show or hide an expression/dimension based on the condition.

For expression: Properties -> Expression -> Select Conditional and give

=MaxString(White) = 'x'

If you attach the sample then it would be easier to give better solution.

Hope it helps you.

Regards,

Jagan.

View solution in original post

11 Replies
Not applicable

In the list box Properties, go to the Presentation tab and insert a condition to the white column...something like:

[White] <> ''

So this column will be showed only if the records is not null.

Show column.png

Creator III
Creator III

Okay, that was helpful but this is for a table box, version 11 Qlikview. Assuming the same principal, properties, general, label...expression set to

=

[White]<>''  

I'm getting -1 as the display for the column. Any thoughts to why that would be?


MVP
MVP

maybe with

=if(len(trim(White))=0,null(),White)

Creator III
Creator III

That expression cleared the label but not the column. The column still displays.

Not applicable

Create the Table like this one, I think you will get the same result. And then you will can occult the column.

Creator III
Creator III

I edited my question to hopefully make it more clear, sorry for the confusion.

Creator III
Creator III

You are way better off using a Straight Table as they have more options.  I haven't used a Table box but a handful of times in the 50+ applications that I have built.

Creator III
Creator III

Thank you, I'll give it a try tomorrow!

MVP & Luminary
MVP & Luminary

Hi,

You don't have much flexibility with Table box, you can go for Straight table where you can show or hide an expression/dimension based on the condition.

For expression: Properties -> Expression -> Select Conditional and give

=MaxString(White) = 'x'

If you attach the sample then it would be easier to give better solution.

Hope it helps you.

Regards,

Jagan.

View solution in original post