Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access

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?

1 Solution

Accepted Solutions
luciancotea
Specialist
Specialist

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

View solution in original post

10 Replies
aaroncouran
Creator III
Creator III

did you reload the document?

sureshbaabu
Creator III
Creator III

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

Thanks

Not applicable
Author

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'..

Not applicable
Author

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'..

mov
Champion III
Champion III

Maybe you have "prohibit binary load" checked?

luciancotea
Specialist
Specialist

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

View solution in original post

Not applicable
Author

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.

mov
Champion III
Champion III

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

Not applicable
Author

Can we impose section access on ADMIN as well??