Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

See attached application on how this can work

Trigger OnOpen used

Highlighted
Not applicable

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

Highlighted
Partner
Partner

Are the clients using Ajax (Webview) or plugin?

Actions and triggers doesn't always work i Ajax.

Highlighted
Not applicable

Hi Jerry,

Any alternative?

Thanks,

Selva