Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sudeepkm
Specialist III
Specialist III

Section Application Multiple fields created circular ref

Hi I'm working on a Section Access implementation. Given below are three tables from which I source data.

SAISSUE.png

The section access has to be implemented for row level reduction of COUNTRY and ORG fields.

When I write the section access script like below I'm getting a circular reference in my data model.

SECTION Access;

USER:

LOAD ACCESS,    USERNAME,    PASSWORD,    OMIT,   ORG,   COUNTRY

FROM SASAMPLETEST.xlsx

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

LOGIC:

LOAD     ORG,  COUNTRY
FROM GFISASAMPLETEST.xlsx

(ooxml, embedded labels, table is Sheet2);

Can anyone pls provide any suggestions?

Regards,

Sudeep

3 Replies
Anonymous
Not applicable

You can merge multiple tables to one,which avoids circular reference

Not applicable

Hi Sudeep, In the Section table you have to kept only one Reduction Field. If you are using 2 reduction fields its won't work. In these cases , you need to create the Composite Key (make more than one key) in the Reduction field and in the data model.

SECTION Access;

USER:

LOAD ACCESS,    USERNAME,    PASSWORD,    OMIT,   ORG&'-'& COUNTRY AS REDUCTIONFIELD

FROM SASAMPLETEST.xlsx

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

LOGIC:

LOAD     ORG,  COUNTRY , ORG&'-'& COUNTRY AS REDUCTIONFIELD
FROM GFISASAMPLETEST.xlsx

(ooxml, embedded labels, table is Sheet2);

Anonymous
Not applicable

I'd like to know (really) where this comes from: "In the Section table you have to kept only one Reduction Field".  I've been using multiple data reduction fields for quite awhile.  Section Access does not create circular references.

See these for more info:

Linking Section Access to multiple dimensions | Packt Publishing

http://www.linkedin.com/groupItem?view=&gid=72977&type=member&item=5826044981596413956&qid=3f9f5dc5-...

Regards.

Michael