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

[Anonymous]

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

[#2]

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.

[Anonymous]

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?

[maxgro]

maybe with

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

[Anonymous]

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

[#6]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[jagan · Accepted solution]

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.