Section Access using email as USERID QlikSense

[jsobrinho]

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

];

[rittermd]

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?

[agigliotti]

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.

[MK9885]

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