Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Multi Layered Section Access

Hi All,

Within my organisation we want to use Section Access.

On a REDUCTION level we have 4 hierachy levels (lets call them 1, 2, 3 and 4 with 1 being CEO and 4 being employee)

Table looks like:


Employee - level1 - level2 - level3 - level4

Employee number - management- business unit - department - team


On a OMIT level we want a sort of profile structure, we were thinking of putting in the OMIT field something like 'Analyst' and refering to a different table in which we specify which columns should be hidden if that role is given. This would look something like:



USER, OFFICE\USER, 1234 (employeenumber), Analyst


With a separate table OMITROLES:


Analyst, Salary


And another separate table OMITGROUPS:


Salary, Year_Salary

Salary, Month_Salary


1. Based on this how would you structure the REDUCTION hierarchy?

2. A User must be specified to either show their own data only, or data from multiple users depending on their role within the organization levels. A Director should only see their own departments and all personel underneith it.

3. Is it possible to refer to a different table for OMIT or REDUCTION thus creating a sort of hierarchy

4. Would this automatically create multiple rows within Qlik for OMIT fiels as a user would have only one row in section access but multiple columns being OMITTED

5. If I have 2 rows in Section Access as below, would this result that user abc will be able to see all departmental data and salary column, or would this result in only being able to see all departmental data and not the salary column?:

USER, OFFICE\abc, 123, salary

ADMIN, Office\abc, department, (null)


Thank you for your support and thinking in advance!


0 Replies