topic Re: How to implement section access at individual sheet level in qlikview in QlikView

How to implement section access at individual sheet level in qlikview

anindya_manna — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to implement section access at individual sheet level in qlikview

zhadrakas — Thu, 03 Nov 2016 06:00:51 GMT

Hello,

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

if(SH1=1,1,0)

regards

tim

Re: How to implement section access at individual sheet level in qlikview

punitpopli — Thu, 03 Nov 2016 06:07:42 GMT

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

Section Access

Re: How to implement section access at individual sheet level in qlikview

anindya_manna — Thu, 03 Nov 2016 06:25:45 GMT

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);