Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vikasshana
New Contributor III

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
New Contributor III

Re: Need help in implementing section access at sheet level

‌can some one help me on my request please.

MVP
MVP

Re: Need help in implementing section access at sheet level

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
New Contributor III

Re: Need help in implementing section access at sheet level

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.