Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
anindya_manna
Partner - Creator II
Partner - Creator II

How to implement section access at individual sheet level in qlikview

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:

USERIDSH01SH02
A11
B01
C10
D11
1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

Hello,

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

if(SH1=1,1,0)

regards

tim

View solution in original post

3 Replies
zhadrakas
Specialist II
Specialist II

Hello,

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

if(SH1=1,1,0)

regards

tim

punitpopli
Specialist
Specialist

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

Section Access

anindya_manna
Partner - Creator II
Partner - Creator II
Author

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