Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Honored Contributor II

Re: User selected default Sheet/tab

See attached application on how this can work

Trigger OnOpen used

Not applicable

Re: User selected default Sheet/tab

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
Valued Contributor II

Re: User selected default Sheet/tab

Are the clients using Ajax (Webview) or plugin?

Actions and triggers doesn't always work i Ajax.

Not applicable

Re: User selected default Sheet/tab

Hi Jerry,

Any alternative?

Thanks,

Selva

Community Browser