In Qlik Sense, row and column level security is handled using something called Section Access. It’s a way to control what data different users can see in an app—based on fields like Type, Location, City, etc.
How to Set Up Section Access To get started, you need to create a security table that defines who can access what. This can be done using an external file (like Excel or CSV), or directly in the Qlik script using an inline table.
Here’s an example using an inline table:
Section Access;
Security: LOAD * INLINE [ USER, ACCESS, LOCATION xyz@mail.com, ADMIN, Mumbai ]; After that, you add:
Section Application; This tells Qlik that the security setup is done and now it should load the actual app data.
Key Things to Remember The field names used in Section Access (like LOCATION above) should be in uppercase—that’s the standard practice.
The values in your security table must match exactly with the values in your data model. If they don’t match, users might not see any data.
There are two types of access:
ADMIN: Can see everything.
USER: Can only see the data assigned to them.
If a user isn’t listed in the Section Access table, they won’t be able to open the app at all.
