Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kerkying
Partner Ambassador Alumni
Partner Ambassador Alumni

Activate Sheet from List Box

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!

1 Solution

Accepted Solutions
marcus_sommer

Maybe like the one within the attachment.

- Marcus

View solution in original post

2 Replies
marcus_sommer

Maybe like the one within the attachment.

- Marcus

kerkying
Partner Ambassador Alumni
Partner Ambassador Alumni
Author

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.