This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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
LOAD * INLINE [
ACCESS, USERID, PASSWORD,REDUCTION,REDUCTIONB
ADMIN, ADMIN, 1234, A,A
USER, AAAA, 1234,B,A
USER, BBBB, 1234, B,B
STAR is *;
LOAD * Inline [
attach is the demo app
access the app once as user AAAA , password 1234
and secondly with user BBBB password 1234
Thank you very much for the info. I'm going to try this and will let you know within the next day or so.