If you want to create rules on what data certain users are allowed to see, you need to use Section Access in your scripts.
Thank you Mr. Magnus Hellfalk for your answer,
I tried to use Section access in Qlik Sense using you proposed link in Qlik Sense Server, but When I finish loading data and open the application , it gives me " Access denied".
I searched on the community website about the solution, there are lots of people with the same problem without any answer.
Before reloading data with Section Access always remember to take a backup f the file since if there is any error in the file you will get locked out of the application.
As far as the link is concerned, it states ACCESS as Admin which doesnt work in Qlik Sense, so avoid use of ADMIN under ACCESS and always remember that all the fields loaded into section access need to be in Upper Case
Yes, good note! Admin is not a viable user in the section access implementation in Qlik Sense. I have two other things that could trigger the response:
- You forgot to add your own user to section access. A common mistake, which I have done many times before... Section access - as it works in Qlik Sense, means that only the users specified will get access to the app. No one else. (This can ofcourse be solved with a workaround)
- The users you specified in the section access where not formated in the correct way. It should be "<domain>/<user>"
Here is a very crude example on a section access. I've written it directly from memory, but should work...
The section access settings will give the user "adam", from the domain "mydomain", access. But he will not see any data from a column called "country".
load * inline [
ACCESS, USERID, OMIT
user, mydomain\adam, COUNTRY,