Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Sheet level access

cancel
Showing results for 
Search instead for 
Did you mean: 
jagan
Luminary Alumni
Luminary Alumni

Sheet level access

Last Update:

Oct 7, 2022 9:27:44 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 25, 2013 8:51:40 AM

Attachments

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

 

UserID Sheet1 Sheet2
A 1 1
B 1 0
C 0 1
D 1 1

 

 

Hope this helps others in implementing Sheet level security.

 

Regards,

Jagan.

Labels (1)
Comments
ali_hijazi
Partner - Master II
Partner - Master II

what is the user name and password

I downloaded the document and it asks me for a userID

Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

sergioabr_tocca
Partner - Contributor II
Partner - Contributor II

Hi,

Give it an A.

Not applicable

Hi,

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

Thanks

jagan
Luminary Alumni
Luminary Alumni

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

sunny_talwar

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.

Not applicable

Hi,

could you please look at it, if you can

Unable to login as User after implementing section access

Not applicable

Thanks for sharing . Good post

Version history
Last update:
‎2022-10-07 09:27 AM
Updated by: