Sheet Access

[smilingjohn]

Please find the screenshot

I have 6 sheets in my dashboard and under User Access I have created 3 users ADMIN and KANE and John .I have also attached the Section Access Snapshot ,

Now my requirement is that I Want to give access to  ADMIN only for MAIN, Member Analysis, and Brand Analysis

Tabs, and remaining Tabs Segmentation and Loyalty to KANE .

Can some one tell me how to achieve this ?.......

Thanks in Advance

[maxgro]

just adapt the solution in the link to your sheets and users

Sheet level access

another one

QlikView App - Show and Hide Sheets based on User or Menu

[smilingjohn]

Thanks Massimo for the reply .

I went through ur post but iam confused how do i use it , becuase already i have section access , can u please go through my attachment and suggest me what needs to be done ? because already i implemented section access based on the access to the brand

[krishna20]

Hi,

Please find the attachment. I have implemented in the excel sheet. Give 1 whomever  to access the sheet and give 0 whomever don't access the sheets.Please let me know if u have further doubts.

[avinashelite]

Hi John,

Please find the attachment for solution:

I have used the user name as ADMIN and KANE Pass= ADMIN@1 and WWE1

ADMIN has access for sheet1 and 2 and KANE has access only for sheet 3

login as ADMIN and see the difference

[smilingjohn]

HI Krishna I am not able to open ur file

[avinashelite]

Hi John,

Please check my below attachment

[smilingjohn]

Hi Avinash,

Thanks for the reply what you  have sent is really help full and appreciated . But i want to implement the same thing to the existing code , becuase i have certain limitation to KANE , Can u please help me out to modify the code to the existing code of my attachment.

Thanks

[krishna20]

Hi,

Please find the below attachment.

[smilingjohn]

HI Avinash Please find the attachment of the Code i modified but this is not working