topic Need help hiding table.. in QlikView

Need help hiding table..

Tue, 09 Jun 2009 23:14:44 GMT

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!

Need help hiding table..

Tue, 09 Jun 2009 23:18:44 GMT

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

Need help hiding table..

Tue, 09 Jun 2009 23:20:41 GMT

Hi,

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

Need help hiding table..

Tue, 09 Jun 2009 23:26:10 GMT

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.

Need help hiding table..

Tue, 09 Jun 2009 23:42:31 GMT

Let me check it out!

Thank you very much for your reply.

Need help hiding table..

Wed, 10 Jun 2009 01:06:33 GMT

Nigel,

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

Thanks again!!!