Sheet Level Scetion Access

Abhishek1 — Sat, 16 Nov 2024 20:36:27 GMT

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

Re: Sheet Level Scetion Access

Abhishek1 — Mon, 24 Jun 2019 07:33:28 GMT

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.

topic Sheet Level Scetion Access in QlikView

Sheet Level Scetion Access

Re: Sheet Level Scetion Access