I have 3 users, one with admin and other 2 guest user.
Both the users should be able to see only their country data, how to achieve this using section access.
If i have to share this to customer, how to achieve the same using api?
This is the load inline i'm typing, but i see nothing changes. all the 3 access to see all the data.
How to achieve this, can anyone help me out in this.
Also i have one more field on which filter needs to be applied
guestuser1 should see brazil data and should see only product A details from brazil area.
Also how to allow the guestuser1 to see sheets 1,3,6 inside app
and guestuser2 to see 2,4,5 within the same app.
first of all I recomend you to write all values of fields in upper case (like ADMIN,BRAZIL...). User property should be in format USER DIRECTORY\USER NAME
For using more than one field for section access I would recomend you to concatenate those filds into one (like Upper(Country)&'/'& Upper(Product) as SA_Field)
Regarding sheets you have to create security rule in QMC which will limit what can users acess. It will be a little bit more complex. Refer e.g. https://help.qlik.com/en-US/sense/June2018/Subsystems/ManagementConsole/Content/rules-resource-filte... or https://help.qlik.com/en-US/sense/June2018/Subsystems/ManagementConsole/Content/security-rules-custo...
Regarding API I do not understand at all what do you mean. Do you want to use it in mashup? It works in same way. Depends on which type of authentication type you choose the data will be shown based on logged-in user.
Hope that helps
If you need to do a data reduction you should use section access, take a look here working with SA in Qliksense qmc
to show/hide a sheet you should create a security rule, take a look at https://help.qlik.com/en-US/sense/September2018/Subsystems/ManagementConsole/Content/Sense_QMC/creat...
I hope this helps.
Before writing the SA script make sure you have all caps in your Country field in your fact...
Upper(Country) as COUNTRY
Star is *;
Load * INLINE [
Fields in SA should be ACCESS, USERID and restricted field not just USER
You can test SA only after you publish the app, not before that.
If for some reason if you cannot access app then right click on the app and 'open without data'
You script seem to be wrong...
First load all the tables for your transformation
Last table should be SA table.
You cannot read from SA table (SA_REGION).. this table wont be available for you once you load it.
Read only from Fact table.
Could you please help me out in writing the script.!It will be helpful if you modify the script.
Right now that app is in Work, So should i publish that app into some stream and check for the SA rules is it?