topic Re: Section Application Multiple fields created circular ref in QlikView

Section Application Multiple fields created circular ref

sudeepkm — Tue, 24 Sep 2013 09:05:11 GMT

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

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

Re: Section Application Multiple fields created circular ref

Anonymous — Mon, 27 Jan 2014 15:34:57 GMT

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

Re: Section Application Multiple fields created circular ref

Mon, 27 Jan 2014 17:32:06 GMT

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);

Re: Section Application Multiple fields created circular ref

Anonymous — Mon, 27 Jan 2014 18:16:06 GMT

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-c62d-4f5e-aeb1-561da…

Regards.

Michael