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.
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()).
