Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Why is OSUser() function inconsistent

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!

2 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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.