topic Re: User selected default Sheet/tab in QlikView

User selected default Sheet/tab

Thu, 17 Jan 2013 13:19:03 GMT

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

Re: User selected default Sheet/tab

giakoum — Thu, 17 Jan 2013 13:30:42 GMT

See attached application on how this can work

Trigger OnOpen used

Re: User selected default Sheet/tab

Mon, 25 Feb 2013 05:37:57 GMT

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

Re: User selected default Sheet/tab

jerrysvensson — Mon, 25 Feb 2013 08:06:51 GMT

Are the clients using Ajax (Webview) or plugin?

Actions and triggers doesn't always work i Ajax.

Re: User selected default Sheet/tab

Mon, 25 Feb 2013 09:39:24 GMT

Hi Jerry,

Any alternative?

Thanks,

Selva