Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Narang__
Contributor
Contributor

Section access

Hi, I am trying to implement section access in my dashboard via a list from SharePoint (user list in SharePoint). For example, a specific user must see data for country= brazil.

  Help me if you have come across this.

#sectionaccess

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Your list must include a reduction column, in order to restrict user access to row-level data, in your example limit users to their countries.

Here's how to implement it in the hidden script.

Section Access;

LOAD Upper(ACCESS) AS ACCESS,
Upper(NTNAME) AS NTNAME,
Upper(CountyCode) AS CountyCode,  /*-- as reduction field
FROM SharePointListSource;

Section Application;