Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Partner - Specialist
Partner - Specialist

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
Champion III
Champion III

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)