Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stringing Functions in Expressions

Chaps,

If I hard code an NT user name in place of MyUserID in the following expression, I get a result of 1...

=sum({< userfield={"MyUserID"}>} x)

If I Let vOSUser = OSUser() and then use in an expression like so I get 1.

=sum({< userfield= {$(vOSUser)} >} x)

How could I put OSUser() directly into an expression so I don't need a variable?

=sum({< userfield= {OSUser()} >} x) ---- This doesn't work.

Any ideas where I'm going wrong?

Thanks,

foldy.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=sum({< userfield= {'$(=OSUser())'} >} x)

View solution in original post

4 Replies
swuehl
MVP
MVP

Try

=sum({< userfield= {'$(=OSUser())'} >} x)

richard_pearce6
Luminary Alumni
Luminary Alumni

try

=sum({< userfield= {'$(=OSUser())'} >} x)


Rgs

Richard

SunilChauhan
Champion II
Champion II

=sum({< userfield= {$(=OSUser())} >} x)


or

=sum({< userfield= {"$(=OSUser())"} >} x)


or

=sum({< userfield= {'$(=OSUser())'} >} x)


hope this helps

Sunil Chauhan
its_anandrjs

You can try with the below scripts in any text box


=sum({< userfield= {'$(=OSUser())'} >} x)

OR

=sum({< userfield= {"$(=OSUser())"} >} x)

OR

=sum({< userfield= {"$(vOSUser)"} >} x)



OR



=sum({< userfield= {"$(=vOSUser)"} >} x)