topic Re: How to avoid circular loops in the Qlikvew Data model in QlikView

How to avoid circular loops in the Qlikvew Data model

Wed, 21 Sep 2011 15:06:05 GMT

Hi All,

Can any one please let me know the different ways of avoiding Circular references in Qlikview...

Awaiting for reply..

Thanks in advance..

How to avoid circular loops in the Qlikvew Data model

Wed, 21 Sep 2011 16:02:55 GMT

hi,

1 ) build your data model by object and merge table by object.

For example, if you have a shoes table and a tshirt table merge that in clothes table.

2) create specific keys between 2 tables.

for example,

TABLE 1

field 1

field 2

field 3

TABLE 2

field 2

field 3

TABLE 3

field 1

field 3

TABLE1

field 1

field 2

field 3

field2 & '-' & field3 as key2

field1 & '-' & field3 as key3

TABLE2

field2 & '-' & field3 as key2

TABLE3

field1 & '-' & field3 as key3

with that TABLE2 and TABLE3 will link with TABLE1 only. no loop

Re: How to avoid circular loops in the Qlikvew Data model

Wed, 07 Mar 2012 14:32:24 GMT

There are multiple ways to remove circular reference in Qlikview data model.

1. Use data island in Qlikview if a specific table is joined with multiple table and creating loop. For example date table is joined with multiple fact tables and creating loop then date table can be kept as date island and in expressions of chart it can be used in if clause. This approach is good but should be used when there is no other approach works because as data grows the performance of application goes down as expression takes time to calculate values.

2. Create link table: In this approach we take out joining fields from multiple fact tables and put them in a link table which then joinied with other tables. you can get examples for it in below threads:

http://community.qlik.com/message/197147#197147

http://community.qlik.com/message/198400#198400

3. Merge two fact table into single table. By this way also we can eleminate loop. See the below thread:

http://community.qlik.com/message/52363#52363

Hope this help,

Anosh