Section Access

[stephenfryer]

Morning,

I have developed a dynamic section access for an app, following the Qlik documentation. As far as I can tell, I have followed it correctly, however, section access is not working as expected. 

Within my model, I do have a field labelled SECTIONACCESSKEY, which only contains [ManagerEmployeeID], so I know this matches the section access script below. If anyone could review my script and point me in the right direction, it would be greatly appreciated.

Some key words have been replaced with 'Dummy' for the purpose of posting on this forum.

/*******************************************************************************
Import default manager access
********************************************************************************/
LIB CONNECT TO 'Dummy';

NoConcatenate
Managers:
SQL
SELECT
'USER' AS ACCESS,
lower([ManagerEmailAddress]) AS [USER.EMAIL],
[ManagerEmployeeID] AS SECTIONACCESSKEY
FROM
[DummySchema].[DummyTable]
GROUP BY
[ManagerEmailAddress],
[ManagerEmployeeID]
HAVING
COUNT([EmployeeName]) > 1;

DisConnect;

/*******************************************************************************
Import default manager access level
********************************************************************************/
NoConcatenate
PermissionsList:
Load
ACCESS
,USER.EMAIL
,SECTIONACCESSKEY
Resident
Managers;
Concatenate(PermissionsList)
LOAD * INLINE [
ACCESS, USER.EMAIL, SECTIONACCESSKEY
ADMIN, stephenfryer@Dummy.co.uk, 0002642
];

DROP TABLE
QlikUsers
,Managers
;

Store PermissionsList into [lib://BI Dev:DataFiles/5099 - Colleague KPI/UserPermissions.QVD](qvd);


Drop Table PermissionsList;

/*******************************************************************************
Section Access
********************************************************************************/
Section Access;
Load
ACCESS
,USER.EMAIL
,SECTIONACCESSKEY
From
[lib://BI Dev:DataFiles/5099 - Colleague KPI/UserPermissions.QVD](qvd)
Where
1=1;
Section Application;

[rubenmarin]

Can you prepare some dummy example app and data that demonstrates the issue and upload it? So we can check what's happening.