Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
You configure your LDAP in the QMC under "Manage Resources", and "User directory connectors"
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.
Thanks. It was correct, for some reason I was unable to see it unless the report was published. Yes LDAP was already there.
great