Section Access

[#1]

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?

[Anonymous]

did you reload the document?

[sureshbaabu]

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

Thanks

[#4]

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

[#5]

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

[Anonymous]

Maybe you have "prohibit binary load" checked?

[luciancotea · Accepted solution]

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

[#8]

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.

[Anonymous]

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

[#10]

Can we impose section access on ADMIN as well??