Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jsobrinho
New Contributor III

Section Access using email as USERID QlikSense

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

];

3 Replies
rittermd
Honored Contributor

Re: 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?

agigliotti
Honored Contributor II

Re: Section Access using email as USERID QlikSense

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.

Khan_Mohammed
Honored Contributor II

Re: Section Access using email as USERID QlikSense

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

Community Browser