topic Re: Load & Trim OSUser variable in QlikView

Load & Trim OSUser variable

Wed, 01 Aug 2012 17:48:07 GMT

I'm trying to implement a "My Assigned Tasks" button whose action selects the currently logged on user (OSUser) from an already existing field (assigned_to). My problem is that the OSUser value needs 11 characters trimmed from the beginning, and this is proving to be difficult. I've put this in the script as a load statement, but get the obvious error that the OSUser field doesn't exist:

LOAD Right(OSUser, Len(Trim)-11) as UserName

;

Once I have the OSUser isolated to match the assigned_to field (which will match after the character trim) I might need some advice/suggestions on how to implement this via a button/bookmark combo or other method. Thanks.

Re: Load & Trim OSUser variable

MayilVahanan — Wed, 01 Aug 2012 18:04:58 GMT

Did you expected something like attached file?

Re: Load & Trim OSUser variable

mphekin12 — Wed, 01 Aug 2012 18:10:13 GMT

Add the 'Select in Field' action on the 'Actions' tab of the Button's properties. Set the Field equal to 'Assigned_To' and the Search String equal to '=right(OSUser(),len(OSUser())-11)'

That should do the trick.

Re: Load & Trim OSUser variable

rwunderlich — Wed, 01 Aug 2012 19:09:05 GMT

If you are trying to pick off the user portion after the domain name:

domain\user

a more flexible expression is:

subfield(OsUser(),'\',-1)

-Rob

Re: Load & Trim OSUser variable

mphekin12 — Wed, 01 Aug 2012 19:36:11 GMT

rob,

thanks for the tip. can you tell me what the -1 parameter means?

Re: Load & Trim OSUser variable

rwunderlich — Wed, 01 Aug 2012 20:42:05 GMT

-1 means first substring from the right.

-Rob

Re: Load & Trim OSUser variable

mphekin12 — Thu, 02 Aug 2012 12:26:38 GMT

Thank you Rob!

Re: Load & Trim OSUser variable

Sun, 05 Aug 2012 15:44:03 GMT

That's exactly what I was looking for, mphekin12; but when I used the search statements you and Rob Wunderlich suggested, nothing happened when I clicked the button. Just to make sure, I did a control experiment with the following entries for the field & search strings:

=app_id

=73

=app_name

="UAR"

Still, nothing was selected after I pressed the button. I don't understand, since I made doubly sure there were no extraneous values selected on the sheet I was working on. Am I using the wrong syntax?

Re: Load & Trim OSUser variable

mphekin12 — Mon, 06 Aug 2012 12:15:40 GMT

bikeking8,

can you post a sample application?

Re: Load & Trim OSUser variable

Mon, 06 Aug 2012 17:39:51 GMT

Just found out this approach wouldn't work given the field values in the database. Sorry to have wasted your time, but I'll close this up correctly.