Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
NenadV
Creator II
Creator II

how to show UserFullName instead of only UserID using the osuser() function?

when all users are loaded from a spreadsheet

Labels (2)
1 Solution

Accepted Solutions
NenadV
Creator II
Creator II
Author

I've resolved it myself in the meantime 🙂

. . .

QVUsers:
load [Authenticated user] as UserID,
FullName as UserFullName
from [..\AllQVUsers.xlsx] (ooxml, embedded labels, table is Sheet1);

vUserName = lookup('UserFullName', 'UserID', upper(OSUser()));

 

View solution in original post

1 Reply
NenadV
Creator II
Creator II
Author

I've resolved it myself in the meantime 🙂

. . .

QVUsers:
load [Authenticated user] as UserID,
FullName as UserFullName
from [..\AllQVUsers.xlsx] (ooxml, embedded labels, table is Sheet1);

vUserName = lookup('UserFullName', 'UserID', upper(OSUser()));