Text box based on OSUser()

[zagzebski]

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.

[#2]

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

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

[#3]

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

[#4 · Accepted solution]

Hi,

You can try something like that:

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