Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Simple Tiered Section Access

I am attempting to setup a simple tiered Section Access for a manager employee relationship. I have reviewed the content (Authorization using a Hierarchy)  and have found it far more complicated then what is needed.

Are there any new or simple Section Access approaches to cover this scenario with the data set below: When a manager logs in they will see all the employees and when the employee logs in they only see their data?

EmployeeOrg:

LOAD * INLINE [

REPORTSTONODE, NODE

12345, 45682

12345, 54821

12345, 21214

12345, 44545

12345, 75756

12345, 45454

12345, 77572

];

Sales:

LOAD * INLINE [

NODE, Sales

45682, 1000

54821, 1000

21214, 1000

44545, 1000

75756, 1000

45454, 1000

77572, 1000

];

1 Solution

Accepted Solutions
hrlinder
Honored Contributor

Re: Simple Tiered Section Access

you should use

section acces:

load * inline [

USERID, ACCESS, NTNAME, NODE

BOSS, USER, BOSS, *

A, USER, ANAME, 45682

B, USER,BNAME, 54821

...

---

every user sees the nodes which are specified (if a user Needs more than 1 node, duplicate the entry)

3 Replies

Re: Simple Tiered Section Access

Hi Matt,

Please find the attachment for the solution.

Please you 1,2,3,4 and 5 as user id to login in and you can see the below employee hierarchy

USERID,Name,Supervisor_id

1,A,0

2,B,1

3,C,2

4,D,2

5,E,1

Not applicable

Re: Simple Tiered Section Access

The attachment did not make it..

hrlinder
Honored Contributor

Re: Simple Tiered Section Access

you should use

section acces:

load * inline [

USERID, ACCESS, NTNAME, NODE

BOSS, USER, BOSS, *

A, USER, ANAME, 45682

B, USER,BNAME, 54821

...

---

every user sees the nodes which are specified (if a user Needs more than 1 node, duplicate the entry)

Community Browser