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: 
Anonymous
Not applicable

Data Reduction in Section Access

I am new to Section Access and I am having some difficulty getting data reduction to load properly.

I have the following script:

Section access;

Load * Inline [

ACCESS, USERID, EmployeeIdOriginal

ADMIN, x\MP11111111, 18190

];

section application;

LIB CONNECT TO 'BI';

LOAD

     RoleName,

    EmployeeIdOriginal,

    RoleSystemCode;

SQL SELECT RoleName,

    EmployeeIdOriginal,

    RoleSystemCode

FROM "BI".BI.RoleView;

Exit Script;

When I open a sheet in the app I only expect to see a RoleName and RoleSystemCode for the EmployeeIdOriginal of 18190 however I am still getting all of the data.  I know that my username is correct because I tested and successfully omitted a field.  Does anyone know why this is occurring?

Thanks

1 Reply
sasiparupudi1
Master III
Master III

Try

Load * Inline [

ACCESS, USERID, EMPLOYEEIDORIGINAL

ADMIN, x\MP11111111, 18190

];

section application;

LIB CONNECT TO 'BI';

LOAD

     RoleName,

    EmployeeIdOriginal As EMPLOYEEIDORIGINAL,

    EmployeeIdOriginal,

    RoleSystemCode;

SQL SELECT RoleName,

    EmployeeIdOriginal,

    RoleSystemCode

FROM "BI".BI.RoleView;

Exit Script;