unable to login as user after implementing section access

[#1]

Hi

sunindia‌   @Sunny T

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

My excel file data

My script for section access to users

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

[#2]

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.

[#3]

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

[#4]

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

[#5]

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]

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.

[#7]

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

[#8]

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

[#9]

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

[#10 · Accepted solution]

Finally see this

[#11]

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