Section Access

nishantswan — Wed, 21 Feb 2024 07:35:03 GMT

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 !!!!

Re: Section Access

Chetan_MN — Wed, 21 Feb 2024 08:47:27 GMT

Hi @nishantswan Below are some of the example scenarios with related to section access, please see if they help you.

https://community.qlik.com/t5/Member-Articles/QlikView-Section-Access-Examples/ta-p/1492719

topic Section Access in App Development

Section Access

Re: Section Access