Qlik Community

QlikView Documents

Documents for QlikView related information.

Sheet level access

MVP & Luminary
MVP & Luminary

Sheet level access

Hi,

This document helps in implementing Sheet level access based on the user using Section Access.  I configured four users A, B, C and D and no password is required to login.

If you login as A, then you can see both Sheet1 and Sheet2.

If you login as B, then you can see only Sheet1.

If you login as C, then you can see only Sheet2.

If you login as D, then you can see both Sheet1 and Sheet2.

The user access is defined in the table

UserIDSheet1Sheet2
A11
B10
C01
D11

Hope this helps others in implementing Sheet level security.

Regards,

Jagan.

Labels (2)
Attachments
Comments
Partner
Partner

what is the user name and password

I downloaded the document and it asks me for a userID

0 Likes
Partner
Partner

Judging by the filename the UserID is either A, B, C or D and no password is required...

0 Likes
Partner
Partner

Hi,

Give it an A.

0 Likes
Not applicable

Hi,

How can i add a prompt message to say to the user when has no access ?

Thanks

0 Likes
MVP & Luminary
MVP & Luminary

There is no such option if you use section access, you can implement this manually, on Document Open trigger get current user and validate the user identity, if it is valid redirect to the Dashboard sheet otherwise show error message.

Not applicable

Hi all

can anyone please help me, why here i am unable login with user B and C. but i am able to login with A and D

Thank you

0 Likes

Not sure why, but after reloading the application, the login for B and C start working again.

Not applicable

oh gr8 yeah, after reloading it is working.

the funny thing is even my document was not loading with users , and it worked now after reloading now. but, i have reloaded it several times before, but its working now only.

0 Likes
Not applicable

Hi,

could you please look at it, if you can

Unable to login as User after implementing section access

0 Likes
Not applicable

Thanks for sharing . Good post

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-07-25 08:51 AM
Updated by: