Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Hiding sheets in Access point - Section Access

I have a requirement to hide few sheets depending on the user logging into the access point to view the app. I'm trying to implement section access but so far not successful. If I check the strict exclusion, none of the users are able to access the app in the access point. It says..the user don't have the permission.

If I uncheck the strict exclusion, All the tabs are visible to all the users. Please advise what am I missing here. Attached is the excel.

Section Access;

LOAD NTNAME,

     USER_ID

FROM

[..\ExternalData\SA_JMPN_Exec.xlsx]

(ooxml, embedded labels, table is Section_Access);

Section Application;

LOAD NTNAME,

     USER_ID,

     SH01,

     SH03,

     SH04,

     SH05,

     SH06,

     SH07,

     SH08

FROM

[..\ExternalData\SA_JMPN_Exec.xlsx]

(ooxml, embedded labels, table is Section_Access);

2 Replies
Highlighted
Master II
Master II

Re: Hiding sheets in Access point - Section Access

Highlighted
Master II
Master II

Re: Hiding sheets in Access point - Section Access

And this:

Section Access