topic listbox with filtered values in QlikView

listbox with filtered values

Tue, 18 Aug 2015 06:35:37 GMT

Good Morning,

I have some difficulties with the entries of a listbox. I create a quicklink-listbox for the users to open Diagrams and Tablebox via Trigger.

Here is the Challenge:

I need to have in the Listbox the entries of all Objects with ObjectType = Pivot-Table or TableBox from the Sheets, that are not hidden.

The Main Problem for me are the "already filtered" entries in the listbox. (It is not about "Hide Excluded" within the properties of the listbox.)

What exactly is the Expression for "if sheet is not hidden"?

At the Moment I see all Objects. he Listbox Expression is: =ObjectID&' '&ObjectName

Does somebody of you have an idea? Would be great.

Thanks alot in advance

Chris

ashwanin — Wed, 19 Aug 2015 05:43:20 GMT

Hi Chris,

Can you please post some sample data?

Wed, 19 Aug 2015 06:24:36 GMT

Good Morning,

please find attached a sample.

The listbox with the blue Header is my quicklink-list.

Here I Need to see just the pivottables and tableboxes from not hidden Sheets.

At the Moment I dont know where to find the info, that a sheet is hidden.

Thank you.

Chris

sundarakumar — Wed, 19 Aug 2015 09:55:42 GMT

Hi Christian,

Is this being created from project files?

-Sundar

Wed, 19 Aug 2015 10:06:23 GMT

Hi sundar,

this file is directly from the source. Please find attached the source file. I want the listbox to work in the source.

Thanks.

Chris