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-filter-advanced-view.htm or https://help.qlik.com/en-US/sense/June2018/Subsystems/ManagementConsole/Content/security-rules-customer-case.htm
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
Thanks for helping out.!
I have a small doubt, if i load the data from SQLServer, should i convert all the reduction field values to upper case is it? If we change the names to upper case, then those values wherever it is used in chart will become invalid, and we should again rename all the fields. Once the solution is out for production, how can we do those changes again in the chart!.
I do not think you would need to use UPPER while extraction from SQL...
Extraction is always RAW data with very minimum transformation I.E using where for dates etc...
Section Access should only be applied in your final app.
Keep the original field and create a new field if you like..
Upper(cd) as C
And use same C field in your section access
Hi agigliotti can you explain the code you are used in this? Why there is concatenation and all?
can you just show how the section access works if there is 2 fields country from table1 and table2. I dont want synthetic key between these two tables, BUt i want section access to be applied on the countries from two tables too.
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/create-security-rules.htm
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'