Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For our application, we need to be able to retrieve the current user ID so that we can use it to look up data entitlements.
Currently, OSUser() is returning "UserDirectory=Directory1; UserId=user234"
What expression can I use to store only "user234" in a variable? I'm having trouble finding String manipulation functions that would help solve this problem in Qlik Sense.
Thank you in advance!
You could use: subfield(subfield(osuser(), ';', 2), '=', 2)
- Marcus
This might work as well
SubField(OSUser(), '=', -1)
Marking this the correct solution because it is a little cleaner. Thank you, both!