Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI guys,
I'm trying to create the app with section access by email in QlikSense, could you please help me, my data isn't reduction
Section Access;
LOAD * inline [
ACCESS, USERID,REDUCTION
USER, DOMAIN\USER, CHICAGO
];
left join
LOAD * inline [
USERID,email
DOMAIN\USER, user@company.com
];
section application;
STAR IS *;
T1:
LOAD * inline [
REDUCTION, Key_City
ALL, *
CHICAGO, Chicago
];
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