topic Re: Regarding Sheet wise Access in QlikView

Regarding Sheet wise Access

Anonymous — Tue, 30 Sep 2014 07:51:22 GMT

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

Re: Regarding Sheet wise Access

ashfaq_haseeb — Tue, 30 Sep 2014 07:53:07 GMT

Hi,

Go through this post.

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

Regards

ASHFAQ

Re: Regarding Sheet wise Access

Anonymous — Tue, 30 Sep 2014 09:30:59 GMT

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.

Re: Re: Regarding Sheet wise Access

ashfaq_haseeb — Tue, 30 Sep 2014 09:33:46 GMT

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

Re: Regarding Sheet wise Access

Tue, 30 Sep 2014 09:41:39 GMT

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

Re: Regarding Sheet wise Access

Anonymous — Tue, 30 Sep 2014 09:50:42 GMT

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

Re: Regarding Sheet wise Access

Anonymous — Tue, 30 Sep 2014 10:18:12 GMT

Hi Joshmi,

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