Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhishek1
Contributor III
Contributor III

Sheet Level Scetion Access

I am trying to implement a sheet level section access. The users based on a field named Project Category. My script is not working and I cant find the reason why.

Here is my script:

SECTION Access;


LOAD * INLINE [

ACCESS, NTNAME, PROJECT CATEGORY, USER

ADMIN, INTRANET\SYSBITECHQVLDNPRD,
ADMIN, INTRANET\SYSBITECHQVLDNUAT,
ADMIN, INTRANET\SYSBITECHQVLDNDEV,
ADMIN,INTRANET\SINGH169_APS,
ADMIN,INTRANET\SINGH169,
USER,INTRANET\YADMANJU_APS, BAU, MANJU
USER,INTRANET\YADMANJU, BAU, MANJU
USER,INTRANET\VERMSOUR, BAU, SOURABH
USER,INTRANET\VERMSOUR_APS, BAU, SOURABH
USER,INTRANET\SHARM328, BAU, SHARM
USER,INTRANET\SHARM328_APS, BAU, SHARM
];

SECTION Application;


LOAD * INLINE [

USER, SH01, SH02, SH03, SH04, SH05, SH06, SH07, SH08, SH09

MANJU,1,0,1,1,0,0,0,0,0,1,1

SOURABH,0,1,1,0,1,0,0,0,0,1,1

SHARM,0,1,1,0,1,0,0,0,0,1,1

];

 

I have 11 sheets in the sheets. I have named them differently. Do i need to name the sheets in the above script accordingly? 

I have checked the Initial Data reduction in the Document properties. But his dosent seem to work

Labels (1)
1 Solution

Accepted Solutions
Abhishek1
Contributor III
Contributor III
Author

I figured it out.

We have to give the sheet names used in the inline table of section access tab and use them as they are in the Conditional part of sheet properties.

View solution in original post

1 Reply
Abhishek1
Contributor III
Contributor III
Author

I figured it out.

We have to give the sheet names used in the inline table of section access tab and use them as they are in the Conditional part of sheet properties.