Section Access on 2 fields

aboliogale — Mon, 15 Mar 2021 09:46:39 GMT

Hello all,

I am trying to implement section access on 2 fields. Following is the structure of my section access file.

ACCESS	E-MAIL ADDRESS	REGION	BUSINESS
ADMIN	USER1@COMPANYNAME.COM	*	*
ADMIN	USER2@COMPANYNAME.COM	MAH	B1
ADMIN	USER3@COMPANYNAME.COM	IND	B2
ADMIN	USER4@COMPANYNAME.COM	*	B1

I have created Key using Region and Business in both data model table and section access table as well.

All values and field names are in upper case. I have checked initial data reduction and strict exclusion checkbox as well.

For the above table, first 3 rows cases are working on the Qlikview desktop. case 4 is not working.

Same file I deployed on UAT and allocate CAL. Still on access point I am getting error as failed to open document. user do not have access.

Please help me with this asap.

PFB Section Access script:

STAR is *;

SECTION Access;

LOAD ACCESS,
'COMPANYNAME\'&upper(subfield(trim([E-MAIL ADDRESS]),'@',1)) as NTNAME,
REGION&'|'&BUSINESS as SECTIONACCESSKEY
FROM
[Sectionaccess.xlsx]
(ooxml, embedded labels, table is [Section Access]);

SECTION Application;

Re: Section Access on 2 fields

Or — Mon, 15 Mar 2021 10:04:02 GMT

For debugging this sort of thing, I would suggest removing the Section Access; part of the code, then looking at the relationships generated for the user that isn't working (since the access aspect will be loaded as a regular table instead of an access table). Usually that helps point you in the right direction for what the problem is.

topic Re: Section Access on 2 fields in QlikView

Section Access on 2 fields

Re: Section Access on 2 fields