How to implement section access at individual sheet level in qlikview

[anindya_manna]

Hi,

I am writing script like this but it is not working.Please help.

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    Admin, A

    User, B

    User, C

    USer, D

];

Section Application;

SheetAccessMatrix:

LOAD USERID,

     SH01,

     SH02

FROM

(ooxml, embedded labels, table is Sheet1);

------------------------------------------------------------------------------------

Data:

USERID	SH01	SH02
A	1	1
B	0	1
C	1	0
D	1	1

[zhadrakas · Accepted solution]

Hello,

did you create a condition on sheet Level to Show/hide the Sheets?

if(SH1=1,1,0)

regards

tim

[punitpopli]

You can refer the community link in below which comprises of helpful section access guides

Section Access

[anindya_manna]

Now I want to use NT name authentication instead of Userid. Will this below code will work?

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME

    Admin, A

    User, B

    User, C

    USer, D

];

Section Application;

SheetAccessMatrix:

LOAD NTNAME,

     SH01,

     SH02

FROM

(ooxml, embedded labels, table is Sheet1);