Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access for Locations and Sales Person

I have created an application with Sales Person by Location. Certain Users I.e. User ABC needs to be able to see all Sales Person's performance within it's location. On the other hand, each sales person should only be able to see their own data. I also have certain Users that should be able to see ALL data for all Sales Person Across all locations. How would I implement this using section access

Also what if One user, should only be able to see 2 out of the 3 location, how would I implement this.

Here are the corresponding fields I have within my data model:

Sales Person: CSR

Location: Location

Help would be immensely appreciated.

1 Solution

Accepted Solutions
Not applicable
Author

Hey I did read the articles. I was trying to use my own domain account at the moment to do this, but it doesn't seem to be working. I am not sure what I am actually missing. Here is what I have

section access;

LOAD * inline [

ACCESS, USERID, REDUCTION, OMIT

USER, GROUP\eruma, 1

];

section application;

T1:

LOAD * inline [

REDUCTION,   location

1, TORONTO

2, VANCOUVER

];

I am logging into qlik via my domain account.

Do I need to separately connect to the LDAP within the app as a data connection?


I don't understand why this is not working

View solution in original post

6 Replies
TKendrick20
Partner
Partner

You must be using Qlik Sense Server, right? Do yourself some reading about section access here: http://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/Security/manage-security-with-...

Here's a quick sample of what it might look like:

section access;

LOAD * inline [

ACCESS, USERID, REDUCTION,    OMIT

USER, domain\admin, *,

USER, domain\CSR1, 4,

USER, domain\CSR1, 2,

USER, domain\CSR2, 1,

USER, domain\CSR3, *, 1

USER,   INTERNAL\SA_SCHEDULER,    *,

];

section application;

T1:

LOAD * inline [

REDUCTION,   Location

1, USA

2, India

3, South America

4, England

5, Australia

];

In this example, the admin can see all locations, CSR1 Can see USA and India, CSR2 can only see England, and CSR3 can see everything except USA.

Not applicable
Author

Hey I did read the articles. I was trying to use my own domain account at the moment to do this, but it doesn't seem to be working. I am not sure what I am actually missing. Here is what I have

section access;

LOAD * inline [

ACCESS, USERID, REDUCTION, OMIT

USER, GROUP\eruma, 1

];

section application;

T1:

LOAD * inline [

REDUCTION,   location

1, TORONTO

2, VANCOUVER

];

I am logging into qlik via my domain account.

Do I need to separately connect to the LDAP within the app as a data connection?


I don't understand why this is not working

View solution in original post

TKendrick20
Partner
Partner

You configure your LDAP in the QMC under "Manage Resources", and "User directory connectors"

TKendrick20
Partner
Partner

Also make sure the cases in your username, the field "location", and all of the records are exactly the same as the data in your database.

Not applicable
Author

Thanks. It was correct, for some reason I was unable to see it unless the report was published. Yes LDAP was already there.

TKendrick20
Partner
Partner

great