Section Access

[#1]

Just upgraded to QlikView 12.

wanted to implement section access like admin can see only admin sheet and user can see only user sheet.

Used below inline section access table.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,FLAG

    ADMIN, ABC, 123,1

    USER, DEF, 678,0

];

Section Application;

For Admin sheet  in sheet property show sheet condition is given FLAG=1 and in user sheet FLAG=0.

it is working fine in QlikView 12 desktop .

Initial data reduction on open in document property is checked with strict exclusion.

From  access point it is working fine for ADMIN But for USER it is throwing error "Failed to open document ,you do not have access to this document".

Please help me on this .

[qliksus]

Do you have only one sheet in your document ? Did you typed the password correctly ?

[tresesco]

Have you checked if the same is working in desktop?

[#4]

Yes, it is working fine in desktop ,I have already mentioned in the query.

Document have 3 sheet , 2 for admin and 1 for user.

[kaushiknsolanki]

Hi,

Try dividing the section access into two different table like below.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ABC, 123

    USER, DEF, 678

];

Section Application;

Load * inline [

USERID, FLAG

ABC,1

DEF,0

];

Now change your conditions to Sum(FLAG)=1 and Sum(FLAG) =0 and check if it works or not.

Regards,

Kaushik Solanki

[#6]

No Kaushik, it is not working on access point.

[#7]

It is working in desktop but not on access point.

[pradosh_thakur]

i may be wrong but under the reload tab of QMC there is a option for section access username and password. if you don't provide it the reload will perform under the username QDS is running. make sure you add that user as ADMIN or Provide the user name password of admin in the reload.

i was facing kind of same issue and this is how i solved it.

as it is section access make sure you have a backup.

regards

Pradosh