I have a table 'Trainings' in my qlik sense data model where I have Fields: User Name, Manager Name, Training Name,....
|
User Name
|
Manager Name
|
Training Name
|
|
JOHN
|
BOB
|
T1
|
|
BOB
|
TIM
|
T2
|
|
CHARLES
|
BOB
|
T3
|
|
SAM
|
RICK
|
T4
|
what I want is when JOHN logins he sees:
|
User Name
|
Manager Name
|
Training Name
|
|
JOHN
|
BOB
|
T1
|
and when BOB logins he sees:
|
User Name
|
Manager Name
|
Training Name
|
|
BOB
|
TIM
|
T2
|
|
JOHN
|
BOB
|
T1
|
|
CHARLES
|
BOB
|
T3
|
So for this I want to create a section access script so that when a user logins he is able to see his training details, but when a manager logins he can see his own training details and he can also see the training details of users reporting to him.
Also I need to find the login id of user so that specific user login ID can be mapped to respective user name. So how to fetch only user id from that as OSUser() gives UserDirectory=DOMAIN;UserId=john, I will need this UserId ‘john’ in upper case as section access will only accept upper case letters
URGENLTY NEED SOLUTION !!!!
