topic Re: Section Access with 2 Fields in QlikView

Section Access with 2 Fields

Anonymous — Tue, 29 Nov 2016 20:20:36 GMT

I have 2 fields that I want to use for Section Access, MODALITY and TERRITORYNUMBER. However, I get a loop (ambiguous joins) when both fields are defined in the Section Application.

This is the Section Application of my file with the 2 fields:

Section Application;
STAR is *;
DocSecurity:
LOAD * INLINE [
SAUSER, TABACCESS.ABOUT, MODALITY, TERRITORYNUMBER
SHC\SVC_SCRIPT, 1, *, 102
SHC\ROBYNR, 1, PET/CT, *
SHC\TESTLOGON2, 1, MRI, *
];

Below shows the loop (dotted lines) with the 2 Section Application fields:

When I only specify 1 field, either MODALITY (see below) or TERRITORYNUMBER in the Section Application, it works.

Section Application;
STAR is *;
DocSecurity:
LOAD * INLINE [
SAUSER, TABACCESS.ABOUT, MODALITY
SHC\SVC_SCRIPT, 1, *
SHC\ROBYNR, 1, PET/CT
SHC\TESTLOGON2, 1, MRI
];

How can I get both MODALITY and TERRITORYNUMBER to work for Section Access?

I'm including a sample QVW named Scans Territory_Modality.qvw so you can see my data model along with the xls files that are included.

Any help would be greatly appreciated! Thanks in advance.

Re: Section Access with 2 Fields

lironbaram — Tue, 29 Nov 2016 21:37:13 GMT

the script below will illustrate how to create two fields data reduction

the concept is to create to separate Data reduction fields in the section access , and to connect

each data reduction field to different field in the model

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,REDUCTION,REDUCTIONB

ADMIN, ADMIN, 1234, A,A

USER, AAAA, 1234,B,A

USER, BBBB, 1234, B,B

];

Section Application;

STAR is *;

LOAD * Inline [

REDUCTION,Modality

A,*

B,MR

];

LOAD * Inline [

REDUCTIONB,TerritoryNumber

A,*

B,102

];

attach is the demo app

access the app once as user AAAA , password 1234

and secondly with user BBBB password 1234

Re: Section Access with 2 Fields

Anonymous — Tue, 29 Nov 2016 23:05:24 GMT

Thank you very much for the info. I'm going to try this and will let you know within the next day or so.