topic Re: Different start sheet based on OSUser when opening the application in QlikView

Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 11:44:15 GMT

I load DomainUser and Sheet in script. The application contains three sheets in GUI. When USER1 opens the application I wan't the sheet USER1 (SH02) to be activated, when USER2 opens the application I wan't the sheet USER2 (SH03) to be activated.

I've added two triggers on open:

1. Select in Field: DomainUser with search string =Upper(OSUser())

2. Activate Sheet: Sheet ID =Sheet

This doesn't work. Any ideas?

Before reloading the script, change the field DomainUser to your DOMAIN and USERNAME (in UPPER CASE).

/Magnus

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 11:56:16 GMT

Hey Magnus,

Create a new variable wich containts the OSUser.

For eg:

vUser=

if(upper(OSUser()='USER1','SH02',

upper(OSUser()='USER2','SH03'))

Then use this variable for the trigger activate sheet

Hope this helps,

Gr.

Frank

Re: Different start sheet based on OSUser when opening the application

sujeetsingh — Tue, 11 Jun 2013 11:58:55 GMT

Framk ,

One question that what about the code where to put the code and how to set default sheet to be opened when document first opened.

Re: Different start sheet based on OSUser when opening the application

Anonymous — Tue, 11 Jun 2013 12:02:14 GMT

You need to change your script:

your sheets are name clmag and clmic

instead of SH02 and SH03

change your script to that

DOMAIn\}USER1 clmag

DOMAIN\USER2 clmic

and it works

Regards

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 12:06:13 GMT

Didn't make any difference!

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 12:06:59 GMT

I've changed the Sheet IDs to SH02 and SH03 but it still doeasn't work!

Re: Different start sheet based on OSUser when opening the application

Anonymous — Tue, 11 Jun 2013 12:13:53 GMT

I have version 11 initial release and for me it works.

See attached file!

Hope it helps

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 12:18:41 GMT

Strange. I've tried your app in 10SR3 and 11SR2 but it doesn't work.

Which sheet is activated when you save thw qvw?

Re: Different start sheet based on OSUser when opening the application

Anonymous — Tue, 11 Jun 2013 12:22:08 GMT

pls open a textbox with "=osuser()". is there a difference in spelling?

This is really strange because in my local app it works as expected!

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 12:26:41 GMT

Exactly the same!

I've noticed that if I save the app on the Dashboard sheet with the DomainUser selected (=OSUser), then sheet SH02 will be activated next time I open the app.

But if I clear all selections and save the app on the Dashboard sheet, then SH02 will not be activated (???).

Re: Different start sheet based on OSUser when opening the application

Anonymous — Tue, 11 Jun 2013 12:49:03 GMT

Its getting more and more strange. Suddenly my app didnot work neither.

Now I added a "select possible - Sheet" before activate sheet.

Try this. Currently it works in my app.

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 12:50:58 GMT

I've tried this earlier but no success. In what state do you save your app?

Re: Different start sheet based on OSUser when opening the application

Anonymous — Tue, 11 Jun 2013 12:56:51 GMT

I save frojm the sheet dashboard.

Try an action "clear all" at first action on open document

Re: Different start sheet based on OSUser when opening the application

Tue, 11 Jun 2013 12:58:17 GMT

I've tried this as well...

Re: Different start sheet based on OSUser when opening the application

Anonymous — Tue, 11 Jun 2013 14:05:24 GMT

I am running out of ideas. Sorry!