topic Re: How to Parse OSUser() and store the result in a variable in App Development

How to Parse OSUser() and store the result in a variable

elijahabel — Sat, 16 Nov 2024 06:57:08 GMT

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!

Re: How to Parse OSUser() and store the result in a variable

marcus_sommer — Wed, 02 Jan 2019 16:23:40 GMT

You could use: subfield(subfield(osuser(), ';', 2), '=', 2)

- Marcus

Re: How to Parse OSUser() and store the result in a variable

sunny_talwar — Wed, 02 Jan 2019 16:33:18 GMT

This might work as well

SubField(OSUser(), '=', -1)

Re: How to Parse OSUser() and store the result in a variable

elijahabel — Wed, 02 Jan 2019 20:12:13 GMT

Marking this the correct solution because it is a little cleaner. Thank you, both!