topic Re: Sheet selection controlled by a listbox in QlikView

Sheet selection controlled by a listbox

Mon, 04 Mar 2013 11:49:17 GMT

Hi,

I'm developing an app where Tabs should be hidden.

How could I switch between sheets using a listbox?

Thanks.

Re: Sheet selection controlled by a listbox

Gysbert_Wassenaar — Mon, 04 Mar 2013 11:57:32 GMT

Add a conditional display expression to your sheets on the properties window of the sheets.

=substringcount(concat(MyField),'Value1') will show the sheet if Value1 is among the selected values.

You could also add a Activate Sheet action to the OnSelect trigger of the field in your listbox to activate the sheet if you select a value in the listbox. You'll need so logic to map the selected value to a sheet ID. Using the same values for the sheet ID's and the listbox values is an easy solution.

Re: Sheet selection controlled by a listbox

Mon, 04 Mar 2013 11:58:02 GMT

Right Click on Tab ..

Go to sheet properties.

In "Show Sheet" select "Conditional"..

There you can write expression.. ListBoxField='FieldValue'

Re: Sheet selection controlled by a listbox

lironbaram — Mon, 04 Mar 2013 12:02:52 GMT

check the attach file

you should look at the tab properties to see the condition for each tab

Re: Sheet selection controlled by a listbox

Mon, 04 Mar 2013 12:04:18 GMT

Ok, I see what you mean.

I'll use the OnSelect trigger I guess.

Thx.

Re: Sheet selection controlled by a listbox

Mon, 04 Mar 2013 12:05:18 GMT

This is not what I actually needed. This would basically show/hide my tab. I don't want to hide it.

Re: Sheet selection controlled by a listbox

Mon, 04 Mar 2013 12:08:37 GMT

I don't have QV installed on my current machine but I'll have a look at that.
Thanks.