topic Re: section access in excel file in QlikView

section access in excel file

pk — Sat, 09 Jan 2021 18:55:16 GMT

hello friends,

am using excel file for section access and columns are like below

ACCESS	NTNAME	PLANTCODE	USER	SH14	SH11	SH12	SH13	SH15
ADMIN	DOMAINNAME\ADMINISTRATOR	<ALL>	DOMAINNAME\ADMINISTRATOR	1	1	1	0	1
USER	DOMAINNAME\SACHIN	1100	DOMAINNAME\SACHIN	1	1	0	0	1
USER	DOMAINNAME\RAHUL	1200	DOMAINNAME\RAHUL	1	1	0	0	0
USER	DOMAINNAME\RAHUL	1300	DOMAINNAME\RAHUL	1	1	0	0	0

below code i have used in application:

SECTION Access;
Access:
LOAD Upper (ACCESS) as ACCESS,
Upper (NTNAME) as NTNAME,
Upper (PLANTCODE) as PLANTCODE,
Upper (USER) as USER
FROM
[$(vSectionAccess)SectionAccess - Operations.xlsx]
(ooxml, embedded labels, table is Sheet1);

SECTION Application;

Sheetlevel:
LOAD Upper (USER) as USER,
SH14,
SH11,
SH13,
SH12,
SH15
FROM
[$(vSectionAccess)SectionAccess .xlsx]
(ooxml, embedded labels, table is Sheet1);

and added condition in sheet properties:

=USER = Only({<SH11={1}>} USER)

Unfortunately this is not working as expected. PLANCODE Wise access restriction is working but sheet level access is not working. all sheets are visible to all users. please help to restrict sheet level access.

Thanks in advance

Re: section access in excel file

MayilVahanan — Sun, 10 Jan 2021 01:53:33 GMT

HI @pk

Based on ur sample, all user has sheet 11 access. so yes, it will display for all users.

Only({<SH11={1}>} USER)

Many examples are available in Community. For basic, please refer below. Hope it helps

https://community.qlik.com/t5/QlikView-Documents/Type-of-Security/ta-p/1490510

Re: section access in excel file

pk — Sun, 10 Jan 2021 09:37:00 GMT

Thanks for revert. All users have access of SH11 but in the sample data there are multiple sheets which are also visible to all user which is incorrect.

Re: section access in excel file

MayilVahanan — Sun, 10 Jan 2021 10:19:02 GMT

HI @pk

Can you provide the sample file and excel sheet to verify

Re: section access in excel file

michal__ — Sun, 10 Jan 2021 12:59:27 GMT

Hi,

try this condition for sheet visibility: =Only(SH11)

Re: section access in excel file

pk — Mon, 11 Jan 2021 07:18:23 GMT

@MayilVahanan refer attached files

Re: section access in excel file

pk — Mon, 11 Jan 2021 17:08:44 GMT

It’s not working

Re: section access in excel file

michal__ — Mon, 11 Jan 2021 19:13:11 GMT

Hi,

the formula i provided returns 1 or 0 and it should work if placed as a sheet visibility condition.

If your reduction on PLANTCODE works perfectly and the USER is associated with respective NTNAME then sheet visibility should work too.