Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasshana
Creator II
Creator II

Need help in implementing section access at sheet level

Hi,

I've the below code in order to give access to the users at the sheet level.

SECTION Access;
LOAD * INLINE [
ACCESS, NTNAME, USER
ADMIN, XYZ\USER, A
USER, XYZ\USER, B
];
SECTION Application;

LOAD * INLINE [
USER, SH01,  SH02
A,1,1
B,1,0
];

Apart from the above code do I've to give any kind of conditions at the sheet level in order to have the code worked?

Regards,

Vikas

3 Replies
vikasshana
Creator II
Creator II
Author

‌can some one help me on my request please.

maxgro
MVP
MVP

try to read this

Section Access

there are 5 lin to sheet security with section access

also this can help you

QlikView App - Show and Hide Sheets based on User or Menu

vikasshana
Creator II
Creator II
Author

Thanks for the links, I've tried the below code in order to give access to users for particular sheets.

Section Access;
LOAD * INLINE [
    ACCESS, NTNAME, NAME
    ADMIN, XYZ\1, A
    USER, XYZ\2, B
];
Section Application;
LOAD * INLINE [
NAME,SHEET
A, 1
B, 2
];

Security_Ref:
LOAD * INLINE [
SHEET, ATM, Windows Server, ATM Checks
1, 1, 1, 1
2, 1, 1, 0
];

As you can see I gave user B access to only ATM and Windows Server sheets when ever I publish User A can able to see all the sheets (ATM, Windows Server, ATM Checks) but user B is facing below.

I've checked Initial reduction in the settings and enabled the conditions at the sheet level as below.

=if(ATM=1,1,0)

=if(Windows Server=1,1,0)

=if(ATM Checks=1,1,0)

but still user B not able to open the document.