Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

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
Highlighted
Not applicable

Re: If a Column is blank in a list box can I supress/hide the column?

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

Highlighted
Creator III
Creator III

Re: If a Column is blank in a list box can I supress/hide the column?

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?


Highlighted
MVP
MVP

Re: If a Column is blank in a list box can I supress/hide the column?

maybe with

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

Highlighted
Creator III
Creator III

Re: If a Column is blank in a list box can I supress/hide the column?

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

Highlighted
Not applicable

Re: If a Column is blank in a list box can I supress/hide the column?

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

Highlighted
Creator III
Creator III

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

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

Highlighted
Creator III
Creator III

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

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.

Highlighted
Creator III
Creator III

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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