Qlik OSUser mapping to the Actual username

[#1]

Hi,

I am trying to map the OSUser function value to the actual user name for the user and have not been successful. I have stored the usernames and user full names in a table and I am using the following set analysis:

=Max({<USER_NAME={'$(=Upper(SubField(OSuser(),'\',2)))'}>} USER_FULL_NAME)

Any help would be great

[Colin-Albert]

Max returns the maximum number, your should use maxstring.

=Maxstring({<USER_NAME={'$(=Upper(SubField(OSuser(),'\',2)))'}>} USER_FULL_NAME)

[Peter_Cammaert]

Or, if every UserID only occurs once in your tble, use Only() like in:

=Only({<USER_NAME={'$(=Upper(SubField(OSuser(),'\',2)))'}>} USER_FULL_NAME)