Regarding Sheet wise Access

[Anonymous]

Hello Everyone,

Here I want to implement sheet wise access through Section access , but I'm facing problem to implement it.

We have three user and one admin user. Please anyone help me .

for accessing I given  as below

I want when login through user then he will access only specific sheet like when we login through abc user then abc user could see only sheet1 .

ACCESS	USERID	PASSWORD	SHEETGROUP
ADMIN	admin	admin	all
USER	abc	123	Sheet1
USER	xyz	234	Sheet2
USER	pqr	567	Sheet3

  Here I'm attaching my qvw and excel file.

Thanks

[ashfaq_haseeb]

Hi,

Go through this post.

http://community.qlik.com/docs/DOC-4435

Regards

ASHFAQ

[Anonymous]

Hi Ashfaq,

Thanks for the reply, here when I'm login through user B and C  then its not opening and give the error access is denied.

[ashfaq_haseeb]

Hi,

Make sure is in Capital Letter A.

have a look at attached image.

If it answered, make sure to close this thread by selecting appropriate answer.

Regards

ASHFAQ

[#5 · Accepted solution]

Hi,

1.Go to sheet 1

2.Sheet Properties--->Conditional-->

'=If( MATCH(UPPER(QVUser()),'ABC','ADMIN'),1,0)'

try to do the similar code for each sheet.

Hope this will work.

Regards,

Joshmi

[Anonymous]

Hi,

First of all convert all section access and join column in upper case. Something like below,

SECTION Access;

Security:

LOAD Upper(ACCESS) as ACCESS,

     Upper(USERID) as USERID,

     Upper(PASSWORD) as PASSWORD,

     Upper(SHEETGROUP) as SHEETGROUP

FROM

Security.xlsx

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

Access:

LOAD Upper(SHEETGROUP) as SHEETGROUP,

     SHEET1,

     SHEET2,

     SHEET3

FROM

Security.xlsx

(ooxml, embedded labels, table is Sheet2);

than use below script in sheet properties conditional sheet,

=Sum(SHEET1) in Sheet1

=Sum(SHEET2) in Sheet2

=Sum(SHEET3) in Sheet3

[Anonymous]

Hi Joshmi,

Thank you so much for the reply. Its working....