-
Re: Section Access using email as USERID QlikSense
Mark Ritter Dec 4, 2017 8:25 AM (in response to jose sobrinho)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?
-
Re: Section Access using email as USERID QlikSense
Andrea Gigliotti Dec 4, 2017 8:36 AM (in response to jose sobrinho)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.
-
Re: Section Access using email as USERID QlikSense
Shahbaz Khan Mohammed Dec 4, 2017 1:19 PM (in response to jose sobrinho)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