Hi @am421,
To apply row-level security in Qlik, you can use the Section Access feature. It's a powerful and flexible way to control data visibility at the row level within your apps.
Example:
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID, REDUCTION_FIELD
USER, USER_A, DATA_A
USER, USER_B, DATA_B
ADMIN, ADMIN, *
];
SECTION APPLICATION;
// Your data load script continues here
In this script:
• ACCESS specifies the level of access (USER or ADMIN).
• USERID is the identifier for the user.
• REDUCTION_FIELD is the field used for data reduction, allowing users to see only their authorized data.
• An asterisk * in the ADMIN row under REDUCTION_FIELD means the admin has access to all data.
For more details you can refer:
https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage...
