topic Re: Comparing OSUSER and user_name in QlikView

Comparing OSUSER and user_name

Sun, 16 Feb 2014 17:21:43 GMT

Hi All,

OSUSER is happiest\keerthi and i have a field called user_name.

User_name has many names such as keerthi, Anil without the domain.

When i click on a button, it should compare OSUSER with the user_name. If user_name matches then particular user_name should be selected.

Please help me with this. i don't know how to check between OSUSER and user_name because of the domain.

Please reply ASAP.

Thanks & Redards,

Keerthi

maxgro — Sun, 16 Feb 2014 17:28:32 GMT

to extract the user from osuser() you can try this

Right(OSUser(), len(OSUser()) - index(OSUser(), '\'))

in a button

select in field

field =

user

search string =

=Right(OSUser(), len(OSUser()) - index(OSUser(), '\'))

swuehl — Sun, 16 Feb 2014 17:29:42 GMT

You can extract the user name only using

=subfield(OSUser(),'\',2)

and you try using this expression as search string in a select in field button action (for selection in field user_name).

Mon, 17 Feb 2014 02:39:10 GMT

Thanks Massimo

Mon, 17 Feb 2014 02:39:30 GMT

Thanks Swuehl