topic Re: Why is OSUser() function inconsistent in QlikView

Why is OSUser() function inconsistent

Wed, 24 Apr 2013 16:06:59 GMT

I have an "Action" for one of my Qlikview buttons that is meant to set a variable "vUser" to the current user's OSUser name, this is to name the exported file with their user name as the first part of the file name. I do the variable rename and then the export in the same button list of actions.

This is how i set the variable:

=TextBetween(OSUser()&'|','\','|')

sometimes, usually the first time but also seems to happen at random times, I click it and the output is "QVAdmin" other times it is the users name like "E12345" and I've even noticed that it will output both file names sometimes... this seems like a qlitch as I only have one export function or "action".

Any ideas? Why does it not get the users OSUser() correctly everytime?

using QV11 desktop and QV11 server, both have this issue when run on the server... maybe an issue with qv and windows interaction?

Thanks!

Re: Why is OSUser() function inconsistent

Anonymous — Wed, 24 Apr 2013 20:19:43 GMT

Not sure if it is related, but maybe gives a hint.

I noticed that if open an aplication with section access in Desktop, QVUser() function returns initially the correct result. Next, if open another application, without section access, not closing the first one, and return to the first, QVUser() returns null. Looks like the result of QVUser() is per QV client session rather than per QV application, and the result is defiend by the last application open.

Regards,

Michael

Re: Why is OSUser() function inconsistent

Wed, 24 Apr 2013 21:03:44 GMT

I also found that if I set a document trigger that OnOpen, Sets vUser to OSUser()
The correct username is used when exporting the file, I guess even when putting the action in the button before the export it somehow doesnt take right away and the export still uses the old variable value.