Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Partner

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
Partner

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