topic Re: Activate Sheet from List Box in QlikView

Activate Sheet from List Box

kerkying — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

We are trying to build a home page that contains a list box of report names. There are multiple sheets that contain reports.

We intend to guide the user from the home page to the reports located in different sheets, by having them select the report names (which are values in a field called Report Names). We are trying Field Event triggers and variable triggers with no luck. Does anyone have any clue?

The current inline load looks like this:

Test:

LOAD

[Report Name],

[Tab Number];

LOAD * INLINE [

Report Name, Tab Number

Report 1, 1

Report 2, 1

Report 3, 1

Report 4, 2

Report 5, 2

];

The reports with tab number 1 is supposed to go to sheet 1, while those with tab number 2 is supposed to go to sheet 2.

Attached the QVW for reference.

Thanks all!

Re: Activate Sheet from List Box

marcus_sommer — Mon, 05 Dec 2016 12:10:56 GMT

Maybe like the one within the attachment.

- Marcus

Re: Activate Sheet from List Box

kerkying — Tue, 06 Dec 2016 01:21:12 GMT

Hi Marcus,

Thanks a bunch. That was the solution I was looking for!

Just for reference, the solution was to include a Activate Sheet with sheet number = pick(match([Tab Number], 1,2), 'SH02', 'SH03') in Document Properties - Triggers.