Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
robynrshields
Contributor III
Contributor III

Section Access with 2 Fields

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.

2 Replies
lironbaram
Partner
Partner

hi

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

robynrshields
Contributor III
Contributor III
Author

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