Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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?
maybe with
=if(len(trim(White))=0,null(),White)
That expression cleared the label but not the column. The column still displays.
Create the Table like this one, I think you will get the same result. And then you will can occult the column.
I edited my question to hopefully make it more clear, sorry for the confusion.
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.
Thank you, I'll give it a try tomorrow!
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.