topic Re: Sheet level section access in Qlikview in QlikView

Sheet level section access in Qlikview

umakrishnaswamy — Mon, 26 Jan 2026 18:19:17 GMT

Hi Team,

I am facing an issue in Sheet level section access

I have done the following steps:

STEP1: wrote script like below:

SECTION ACCESS;

LOAD * INLINE

[

ACCESS,NTNAME,GROUP

ADMIN, QLIKID,ALL

ADMIN,MYNTNAME,GRP

USER,SPECIFICID,GRP1

];

SECTION APPLICATION;

SHEET_ACCESS:

LOAD *INLINE

[

GROUP, SH01,SH02

ALL,1,1,

GRP,1,1,

GRP1,1,0

];

STEP 2: enabled strict exclusion in document properties

STEP3: also wrote conditional hiding in sheets like (SH01=1 etc)

After reload the file and saved. When i am checking the file in local it is working for me and other users as well.

But after published the same application in access point, i am getting the error when i tried to open the file.

failed to open the document. you don't have access to this document.

Note: When i wrote the same NT name for Data level security it is working in access point. Only sheet level is not working

Can any one please advice is there any step i am missing . please help me to solve this issue.

Thanks and Regards,

Uma.k

Re: Sheet level section access in Qlikview

Miguel_Angel_Baeyens — Wed, 21 Aug 2019 14:39:28 GMT

If the application is not reloaded with all data, you may be eventually opening a file with no sheets, and the error could be because of that.

Test first that row level security works, then check the conditions for the sheet.

Note that

SH01 = 1

will be false if the same user has more than one different value, so instead use something like

Max(SH01) = 1

or similarly suitable function.

Think of what is the difference between local and server, different account names, headers, etc.

Re: Sheet level section access in Qlikview

shiveshsingh — Wed, 21 Aug 2019 14:53:00 GMT

May be you can use Fieldindex('Field Name', 'Compare Value')>0 in conditional statement.

Re: Sheet level section access in Qlikview

umakrishnaswamy — Thu, 22 Aug 2019 07:33:12 GMT

Thank you!. But if a qlikview file with out any data and have only sheets also facing the same problem.

Re: Sheet level section access in Qlikview

Brett_Bleess — Tue, 03 Sep 2019 16:11:25 GMT

Uma, have a look at the following Design Blog post, and note there are further links at the bottom of that post too. Hopefully this may give you some further help/ideas on how to go about things in your use case.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Regards,
Brett