Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aboliogale
Contributor II
Contributor II

Section Access on 2 fields

Hello all,

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

ACCESSE-MAIL ADDRESSREGIONBUSINESS
ADMINUSER1@COMPANYNAME.COM**
ADMINUSER2@COMPANYNAME.COMMAHB1
ADMINUSER3@COMPANYNAME.COMINDB2
ADMINUSER4@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;

Labels (2)
1 Reply
Or
MVP
MVP

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.