Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reanfadyl
Partner - Creator
Partner - Creator

Section Access: One table different levels of access for the same user

Hello Qlik Folks,

A question for all you Section Access gurus out there.  I am needing to provide a user, different levels of access to the same data table e.g.:

The table:

EmployeePayFacts:

$ Value

Cost CentreID

EmployeeID

EmployeeManagerID

The requirements:

  1. A manager may access detail employee level data for their staff  only e.g. filter by the EmployeeManagerID
  2. A manager may access aggregate  Cost Centre level data for all Cost Centres (regardless of EmployeeManagerID)

I considered creating two tables one with $ values at an Employee Level, and another at CostCentre level and use Section Access separately for each table. Problem is I would like to avoid the overhead of extra records.

Any ideas?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can't apply different section access rules to different fields of the same record of the same table. You'll have to create another table.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

You can't apply different section access rules to different fields of the same record of the same table. You'll have to create another table.


talk is cheap, supply exceeds demand