Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Use QVUser to Lookup First Name in Employee table.

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

2 Replies
aadilmadarveet
Valued Contributor

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

Try something like this in a text box first.

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

or

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

Not applicable

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

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)