Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help hiding table..

Hi,

I am pretty new to QW and wondering if you can help me out with this.

Currently, I have the following setup on my 'Main' tab...

- List box with 4 choices (A,B,C,D,E)

- Ranked Straight Table with Object ID CH01,CH02,CH03 and CH04

- Sheet 1, Sheet2, Sheet3 and Sheet4 contains clones of CH01,CH02,CH03 and CH04

I would like to do perform the following

Scenario 1

- When clicking on A in List box, I would like to hide CH02,CH03 and CH04

- When clicking on B in List box, I would like to hide CH01,CH03 and CH04

Scenario 2

- When clicking on A in List box, I would like to show Sheet1 and Main

- When clicking on B in List box, I would like to show Sheet2 and Main

Is it GetCurrentSelections that I need to use?

Thank you very much for your help!

1 Solution

Accepted Solutions
Not applicable
Author

OK

So you need to create a variable, let's call this vListBoxSelected, and the value of the variable is =GetFieldSelections("fieldname") where the field name is the same field name that you are using in your list box. This will mean you have a variable with the contents of your selection.

Then, in your straight table, say CH01, go to the properties and to the layout tab, change the show type to conditional and put in the following condition

vListBoxSelected='A'

That should do the trick........

Obviously for CH02, CH03, CH04 etc you need to put in the same condition but with different values.

Good luck,

Nigel.

PS: If you struggle with this, post a sample of your app and I'll take a look.

View solution in original post

5 Replies
Not applicable
Author

Can you tell me which version of QVW you are using?

Not applicable
Author

Hi,

Thank you for replying. I am currently using QW 8.5 Developer version.

Not applicable
Author

OK

So you need to create a variable, let's call this vListBoxSelected, and the value of the variable is =GetFieldSelections("fieldname") where the field name is the same field name that you are using in your list box. This will mean you have a variable with the contents of your selection.

Then, in your straight table, say CH01, go to the properties and to the layout tab, change the show type to conditional and put in the following condition

vListBoxSelected='A'

That should do the trick........

Obviously for CH02, CH03, CH04 etc you need to put in the same condition but with different values.

Good luck,

Nigel.

PS: If you struggle with this, post a sample of your app and I'll take a look.

Not applicable
Author

Let me check it out!

Thank you very much for your reply.

Not applicable
Author

Nigel,

Thank you so much for your help. This helps me a lot.

Thanks again!!!