Discussion board where members can get started with Qlik Sense.
I'm trying to create the app with section access by email in QlikSense, could you please help me, my data isn't reduction
LOAD * inline [
USER, DOMAIN\USER, CHICAGO
STAR IS *;
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.
USER, DOMAIN\USERNTNAME, 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