Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
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