topic Re: Use QVUser to Lookup First Name in Employee table. in QlikView

Use QVUser to Lookup First Name in Employee table.

Tue, 24 Mar 2015 09:00:02 GMT

Hopefully this is just a quick question I’m using QVUser() to get the users login, but I want to display the users first name in a Text Box. I have an Employee table where I have stored both the login name and the users first name.

I thought it was just a quick case of using Lookup but this is not available as a function ?

Thanks Mark

Re: Use QVUser to Lookup First Name in Employee table.

Anonymous — Tue, 24 Mar 2015 09:54:45 GMT

Try something like this in a text box first.

= Only({<ClientUserName = {"=QVUser()"}>} ClientFirstName)

= Only({<ClientUserName = {"QVUser()"}>} ClientFirstName)

Re: Use QVUser to Lookup First Name in Employee table.

Tue, 24 Mar 2015 12:19:10 GMT

Hi Aadil

Thanks for quick reply have tried following without any luck. All Users login Id is 8 characters long, that why I have used the "Right" function just to look at the last 8 characters of the login string.

=Only({<LOGIN = {"=right(OSUser(),8"}>} EmployeeFirstName)

=Only({<LOGIN = {"=(right(OSUser(),8)"}>} EmployeeFirstName)

=Only({<LOGIN = {"(right(OSUser(),8)"}>} EmployeeFirstName)

=Only({<LOGIN = {"right(OSUser(),8"}>} EmployeeFirstName)