Section Access using email as USERID QlikSense

The UserID in section access has to be the same login the user uses to login to Qlik.

How are you syncing your users into Qlik in the first place?

your script looks fine.

the user DOMAIN\USER, that has to be replaced with the user windows account, should see only Key_City of Chicago.

you can't use email as USERID in Section Access because the user logged in is being authenticated by Windows.

STAR IS *;

Section Access;

LOAD * inline [

ACCESS, USERID,REDUCTION

ADMIN,INTERNAL\sa_scheduler,*

USER, DOMAIN\USERNTNAME, CHICAGO

];

left join

LOAD * inline [

USERID,email

DOMAIN\USER, user@company.com

];

section application;

T1:

LOAD * inline [

REDUCTION, Key_City

ALL, *

CHICAGO, Chicago

];

Not sure why you are doing left join? I do not think you can reduce the data based on an email id.

Sometimes you'd have to use Service account (User ID used to reload the data in QMC) I.E Internal\sa_scheduler