Using OSUser in SetAnalysis

[SebastienPreau]

Hello,

We need to use the OSuser in a SetAnalysis in QlikSense September 2018.

So far, we have tried this :

[PERIM_CRCO.TYPE_PERIM]={'PERIM_OPE'},[PERIM_CRCO.C_LOGINAD]={"=upper(subfield(OSuser(),'=',3))"}

or

[PERIM_CRCO.TYPE_PERIM]={'PERIM_OPE'},[PERIM_CRCO.C_LOGINAD]=upper(subfield(OSuser(),'=',3))

but none seems to work.

NB :

=> we do not want to use Security as we want to have several values for PERIM_CRCO.TYPE_PERIM

[agigliotti]

what means '=' sign in subfield ?

[SebastienPreau]

OSUser returns something as Domain = XXX; Userid = spreau

As i just want spreau, i use subfield

[SebastienPreau]

I mean subfield is used to retrieve the third part of the string when cut along the character '='

[agigliotti]

are you sure?
I got "domain\username" pattern as OSUser() output.

[SebastienPreau]

[SebastienPreau]

I Suppose the pattern may vary depending on the way the server is linked with AD ?

[agigliotti · Accepted solution]

yes could be as you said.
let's try using the below expression in your set analysis:
[PERIM_CRCO.C_LOGINAD] = {"=$(=upper(subfield(OSuser(),'=',3)))"}

I hope it can help.

[SebastienPreau · Accepted solution]

[PERIM_CRCO.C_LOGINAD] = {"$(=upper(subfield(OSuser(),'=',3)))"}

Works !!!

Thanks.

We are going to test passing it through a variable and if OK, problem solved !