Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sudeepkm
Valued Contributor 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
neetha_p
Honored Contributor

Re: Section Application Multiple fields created circular ref

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

Not applicable

Re: Section Application Multiple fields created circular ref

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

mov
Esteemed Contributor III

Re: Section Application Multiple fields created circular ref

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

Community Browser