Hierarchy in section access

[sumantamandal12]

Hi,

I have a table like below :

TAB:

LOAD

EMP_NAME,

MANAGER_NAME,

SALARY

FROM ...TEST.XLSX;

How can I create section access so that each employee when log in can see their own data and when manager log in they can see their data as well as their reportees data.

[Or]

https://community.qlik.com/t5/Qlik-Design-Blog/Authorization-using-a-Hierarchy/ba-p/1476319

[sumantamandal12]

Actually I checked the blog but how can I implement that in my structure.

[sumantamandal12]

Any help on this??

[sumantamandal12]

I have written the script like below but it is not working:

SECTION Access;
LOAD 'USER' as ACCESS,
[Staff Name] as STAFF_NAME,
Upper([Staff Name]) as PERMISSION
FROM
[C:\Users\manda\Desktop\Hierarchy_test_data.xlsx]
(ooxml, embedded labels, table is Sheet1);

SECTION Application;
THierarchy:

HierarchyBelongsTo([Staff Name],[Manager Name],DESIGNATION,AncestorID,AncestorDesignation)

LOAD [Staff Name],
[Manager Name],
DESIGNATION
FROM
[C:\Users\manda\Desktop\Hierarchy_test_data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Hierarchy:
Load
[Staff Name] as NAME,
AncestorID,
Upper(AncestorID) as PERMISSION

Resident THierarchy;
DROP Table THierarchy;

Fact:
load * inline
[
NAME,SALARY,PROJECT
A,10000,QA
B,40000,QIS
C,25000,QCT
D,30000,SFDC
E,45000,LMS
F,15000,TMS
G,65000,HMS
];