topic Re: Need help in implementing section access at sheet level in QlikView

Need help in implementing section access at sheet level

vikasshana — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Need help in implementing section access at sheet level

vikasshana — Sun, 10 Dec 2017 16:40:40 GMT

‌can some one help me on my request please.

Re: Need help in implementing section access at sheet level

maxgro — Sun, 10 Dec 2017 17:23:25 GMT

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

Re: Need help in implementing section access at sheet level

vikasshana — Mon, 11 Dec 2017 12:32:52 GMT

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.