Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

unable to login as user after implementing section access

Hi

sunindia‌   @Sunny T

I have implemented section access to provide sheet level access to Users.

My excel file data

section.PNG

My script for section access to users

sacode.PNG

with the above code, I am able to login as USER A but not as other user(B,C, D)

I am getting the errors as "Access denied to this document".

can anyone please help me with this.

Thanks in Advacne

41 Replies
Not applicable
Author

Thank you very much for the file .

With this file, I am able to login to the application with different users without any difficulty.

But, every user is able to see all the sheets,

i have loaded the excel sheet again from my system location and changed the sheet IDs in load inline statement according to the document. but when i try to reload after these changes, i am unable to reload and i am getting the error, qlikview not responding.

Not applicable
Author

Thank you for the solution

when i try load the file from recent documents, with and without data, i am able to login to the application.

I am able to login with users , though i open the document with reload data.

I dont know, how it works, when i upload it on the server. but for now i am able to login to the application with users,

could you help me in restricting the sheet access to users. since, all my users are able to see all the application now. but i want the users able to see only one document.

regards

Ganesh

Not applicable
Author

Hi See the attached qvw.

Here i am able login as a admin and able to see all sheets.

userid:B sheetname:Line01 able to see

userid:C sheetname:Line02 able to see

userid:D sheetname:Line03 able to see


This is the way i am able to open the file

Not applicable
Author

wow.. great sir.

But, Why i am able to see live production sheet for all the users?

if you could help me with that, i am done sir

regards

ganesh

Chanty4u
MVP
MVP

If u give access to Admin.  as he can see all the sheets .

Based on user restriction Access to perticular sheets. users can see only that sheets.

Not applicable
Author

There is no data on that sheet that"s why condition not applied for that sheet.if you want you can for specific user.

Not applicable
Author

oh great sir

Thank yo so much.. i  will try it by connecting to database and see if i have any other problems.

but you saved me with this sheet level access

Thank you sir

Not applicable
Author

since there is no data on that sheet, restriction is not applicable to that sheet it seems

Not applicable
Author

Finally see this

Not applicable
Author

how it is removed sir, though that sheet is empty??