If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I wanted to know if someone could help me out with section access in Qlik Sense.
I have a large data set that needs to be filtered as per the user log in credentials.
Each user should only be able to access a limited amount of data and the rest should be filtered out.
Can someone please suggest a way I can achieve this in Qlik Sense?
These are good articles about Section Access in Qlik Sense:
You can also use custom rules for controlling access to Streams, Apps, Sheets and App Objects:
Hope this helps,
Identify the lowest level of data and associate the field to section access script in QlikSense.
There is no option in QlikSense to enable/disable security.
Also another note, section access will work only in enterprise version and not in desktop.
See below script for reference
LET vLevels=Len(KeepChar(vHierarchyDef,',')) + 1;
LOAD * INLINE [
ACCESS, USERID, REDUCTION
USER, US\SALIDINA, ILLINOIS
USER, US\SREEDENON, TEXAS
USER, SK, CHICAGO
For vAncLevels= 1 to vLevels
UPPER([$(vAnc)]) as REDUCTION,
Notes from above script
1. This script will reduce the data based on hierarchy level (Country, State and City). If your data do not have hierarchy, specify the column name in vHierarchyDef variable (For example if you want to reduce data only to Country level, only specify Country
2. For ADMIN, REDUCTION column is empty, means access to all data
3. SALIDIN is able to see only data for ILLINOIS state
4. SK is able to see only data for Chicago city
Another important note, if by any chance your load failed, you can still enter into the script by right clicking the app in work folder (hub) and click open without data and perform changes.
If you face any difficulty, please let us know
Note: Link provided by Carlos is a good starting point to implement security in QS