Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

User selected default Sheet/tab

I'd like to create a User Preferences sheet in my app where the user can select/set things like the default sheet that opens when the app is opened.

So here's what I did to accomplish this (needless to say, it's not working):  In the script I created an inline table of sheet names and sheet IDs similar to:

[Sheet List]:

Load * inline [

sheet_name, sheet_id

Dashboard, dashboard

Foo, foo_123

Bar, bar_id

];

I then created a User Preferences sheet with a list box that displays sheet_name.

Next I defined  a variable under Variable Settings: vDefaultSheetID = %sheet_id

Lastly I defined a document Open Action to  set active sheet = vDefaultSheetID.

What am I doing wrong?

Thanks,

Steve

4 Replies
giakoum
Partner - Master II
Partner - Master II

See attached application on how this can work

Trigger OnOpen used

Not applicable
Author

Hi Steve,

Go to Document properties and Add one "Document Event Trigger"

OnOpen--> Add Action-->Layout---> Activate Sheet--> In Macro Name "SH01"

SHO1 is sheet name

Thanks,

Selva

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Are the clients using Ajax (Webview) or plugin?

Actions and triggers doesn't always work i Ajax.

Not applicable
Author

Hi Jerry,

Any alternative?

Thanks,

Selva