topic Stringing Functions in Expressions in QlikView

Stringing Functions in Expressions

Wed, 07 May 2014 15:20:09 GMT

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.

swuehl — Wed, 07 May 2014 15:24:09 GMT

Try

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

richard_pearce6 — Wed, 07 May 2014 15:24:13 GMT

try

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

Rgs

Richard

SunilChauhan — Wed, 07 May 2014 15:27:56 GMT

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

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

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

hope this helps

its_anandrjs — Wed, 07 May 2014 15:53:28 GMT

You can try with the below scripts in any text box

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

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

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

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