Linking OSUser to EmployeeId

[#1]

Hi everyone,

I am trying to create a permissioning model for a tab of my qlikview app. Therefore I would like to somehow link OSUser to EmployeeId. Currently by just using:

OSUser()

it recognises which user has logged onto the dashboard.

This is a sample of a table of some of the other data I have brought in.

ECDEmployeeId	ECDNTAccount
68244	FM\123456
93328	FM\123457
83276	FM\123458
87230	FM\123459
83160	FM\123460
158724	FM\123461
105484	FM\123462
95232	FM\123463
13334	FM\123464
13334	FM\123465
93914	FM\123466
93914	FM\123467
113351	FM\123468
113351	FM\123469

I then put in the code in a separate table:

Load
upper(OSUser) as ECDNTAccount;

I want to be able to write some code where the dashboard would recognise the OSUser and then take the corresponding EmployeeId from this. However, all methods so far have not been successful. Has anyone any ideas how to do this? I tried using getcurrentselections function but again, it did not work.

[#2]

You can try to put a trigger in the document properties. Access the property of the document and go on the tab trigger. Add a trigger selection, where the field ECDNTAccount receive the contents of the function upper (OsUser()).

Regards,

Tonial.