Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kerkying
Partner
Partner

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
MVP & Luminary
MVP & Luminary

Maybe like the one within the attachment.

- Marcus

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe like the one within the attachment.

- Marcus

View solution in original post

kerkying
Partner
Partner
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.