topic Re: Section Access in QlikView

Section Access

Mon, 26 Jan 2026 18:19:17 GMT

I am trying the section access on my qlikview document and I have a hidden script as below:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN,ADMIN

USER, JDOE, JDOE

USER, JYER, JYER

USER, ANU, ANU

];

Section Application;

LOAD * INLINE [

USERID , BUSINESS_UNIT

JDOE, MPRS

JYER, MPT

ANU, MSH

];

And have enabled the '

Check the Initial Data Reduction Based on section Access

Strict Exclusion' in the Document Settings

But when I open the document , it doesnt prompt me for a userid and PAssword instead it just opens the documents with all the data.

What needs to be done?

Re: Section Access

Anonymous — Wed, 22 Jan 2014 17:16:40 GMT

did you reload the document?

Re: Section Access

sureshbaabu — Wed, 22 Jan 2014 17:25:33 GMT

your script should work. Please reload -> Save the document-> re-open it again.

Thanks

Re: Section Access

Wed, 22 Jan 2014 18:43:17 GMT

I did a reload however I have a binary Load statement within my script .It is giving me the following error...

'Unknown statement

Binary d:\qlikstorage\userdocuments\data_model.qvw'..

Re: Section Access

Wed, 22 Jan 2014 18:43:29 GMT

I did a reload however I have a binary Load statement within my script .It is giving me the following error...

'Unknown statement

Binary d:\qlikstorage\userdocuments\data_model.qvw'..

Re: Section Access

Anonymous — Wed, 22 Jan 2014 19:03:18 GMT

Maybe you have "prohibit binary load" checked?

Re: Section Access

luciancotea — Wed, 22 Jan 2014 19:14:40 GMT

You inherit the security from the other qvw and it is overwriting yours. You have to move the binary load before Section Access.

Re: Section Access

Wed, 22 Jan 2014 19:17:49 GMT

No I have not done that... I was aoble t fix it by moving the binary load before the Section Access. Now it works fine.

Re: Section Access

Anonymous — Wed, 22 Jan 2014 19:21:30 GMT

From help:

Only one binary statement is allowed in the script and it can only be put as the first statement of a script

(I thought you had "prohibit binary" in the source file, which is common if you have section access there.)

Re: Section Access

Fri, 24 Jan 2014 18:32:13 GMT

Can we impose section access on ADMIN as well??

Re: Section Access

Nicole-Smith — Fri, 24 Jan 2014 19:15:52 GMT

Yes. Anyone with ADMIN privileges is also affected by section access.

Re: Section Access

jpk — Tue, 07 Sep 2021 11:32:54 GMT

Hi Everyone

Really great post, most appreciated.

Ebiexperts a Qlik Technology partner has launched an automated Section Access product to the market.

The product is called SAM: Section Access Manager for Qlik

Qlik Integrated & Authenticated
Self-service no-code
Automation options
Active Control SingleTouch
Admin
E-Learning

This is the MVP release and fully automated. I have attached the brochure.

Regards