Qlik Community

Ask a Question

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Why the user can still access all data after applying section access restriction?

Hi, all.

Question:

  • I want to restrict users to the data only under their corresponding departments. But all the users can still have all the access even after applying the session access restriction below.
  • The wield thing is it worked a few moth ago with the same code and data.  But no matter how many times I tried now, I can't restrict the data access to users any more.
  • Please help me figure this out if you encountered same issue or similar issue before. 

 

Session Access Code:

section access;
LOAD * inline [
ACCESS, USERID,REDUCTION
USER,MZHAO,FINANCE
USER,ECHAO,SALES
];

section application;
T1:
LOAD
Key,
Upper(Department) AS REDUCTION
[lib://DOWNLOAD/TestData.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

TestData Sample:

KeyDepartmentMonthVolume
1FinanceJan-2010
2FinanceFeb-2015
3FinanceMar-2022
4FinanceApr-2030
5SalesJan-2018
6SalesFeb-2023
7SalesMar-2019
8SalesApr-2061
0 Replies