topic Text box based on OSUser() in QlikView

Text box based on OSUser()

zagzebski — Fri, 11 Jul 2014 20:02:12 GMT

I have a USER table in QlikView with a list of QlikView users who could potentially log in. I want to create a text box with the last name of the user who has logged into QlikView.

One of the fields is USERNAME which is essentially the OSUser() name.

For example if I log in the OSUser() name is "DH\SCAT" and in the USERS table there is a match on USERNAME I want to pull back the LASTNAME field. So...

If OSUser()=DH\SCAT and USERNAME=DH\SCAT then the text box should show the LASTNAME field of "CAT".

Thanks in advance.

Re: Text box based on OSUser()

Fri, 11 Jul 2014 20:41:30 GMT

Would parsing out the lastname from OSUser() work? If that's the case, you can try something like this:

SubField(OSUser(), '\', 2)

Re: Text box based on OSUser()

Fri, 11 Jul 2014 21:23:05 GMT

Does your USER table have last name as a column? if yes, then use a if statement?

Re: Text box based on OSUser()

Sat, 12 Jul 2014 03:59:29 GMT

Hi,

You can try something like that:

=Only({$<username = {'$(=OSUser())'}>} lastname)