topic Re: Sheet Access in QlikView

Sheet Access

smilingjohn — Wed, 08 Jul 2015 05:15:55 GMT

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

Re: Sheet Access

maxgro — Wed, 08 Jul 2015 05:28:58 GMT

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

Re: Sheet Access

smilingjohn — Wed, 08 Jul 2015 05:32:02 GMT

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

Re: Sheet Access

krishna20 — Wed, 08 Jul 2015 05:46:29 GMT

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.

Re: Sheet Access

avinashelite — Wed, 08 Jul 2015 06:30:24 GMT

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

Re: Sheet Access

smilingjohn — Wed, 08 Jul 2015 07:01:40 GMT

HI Krishna I am not able to open ur file

Re: Sheet Access

avinashelite — Wed, 08 Jul 2015 07:03:56 GMT

Hi John,

Please check my below attachment

Re: Sheet Access

smilingjohn — Wed, 08 Jul 2015 07:06:01 GMT

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

Re: Sheet Access

krishna20 — Wed, 08 Jul 2015 07:16:52 GMT

Hi,

Please find the below attachment.

Re: Sheet Access

smilingjohn — Wed, 08 Jul 2015 07:17:48 GMT

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

Re: Sheet Access

avinashelite — Wed, 08 Jul 2015 07:49:01 GMT

Hi John,

with the existing code we cannot achieve the tab access , you need to alter the script like the example I have provided

Re: Sheet Access

smilingjohn — Wed, 08 Jul 2015 08:34:27 GMT

Thanks Avinash