How to avoid circular loops in the Qlikvew Data model

[#1]

Hi All,

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

Awaiting for reply..

Thanks in advance..

[#2]

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

[#3]

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