Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You can try something like that:
=Only({$<username = {'$(=OSUser())'}>} lastname)
Would parsing out the lastname from OSUser() work? If that's the case, you can try something like this:
SubField(OSUser(), '\', 2)
Does your USER table have last name as a column? if yes, then use a if statement?
Hi,
You can try something like that:
=Only({$<username = {'$(=OSUser())'}>} lastname)