2 Replies Latest reply: Mar 7, 2012 9:37 AM by Anosh Nathaniel RSS

    How to avoid circular loops in  the Qlikvew Data model

      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

          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
            Anosh Nathaniel

            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