Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Activate Sheet from List Box

Maybe like the one within the attachment.

- Marcus

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Activate Sheet from List Box

Maybe like the one within the attachment.

- Marcus

View solution in original post

Partner
Partner

Re: Activate Sheet from List Box

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.