9 Replies Latest reply: Jan 24, 2018 10:22 AM by Petter Skjolden RSS

    Understanding circular reference and joins

    Mohamed Ilyas Pitchai Mohamed

      Hi All

      I have difficulty in understanding circular reference (loops) in Qlik Sense (Qlik Sense Desktop 3.2 SR5)

       

      I have below tables that logically connects as below:

      1. Suppliers --> Purchase Orders (PO Header) --> PO Line Items (PO Details)

      2. Suppliers --> Contract Lines (Header & Detail in one view)

      3. Materials --> PO Line Items (PO Details)

      4. Materials --> Contract Lines (Header & Detail in one view)

       

      I'm loading below

      MasterTransaction - 1Transaction-2
      Suppliers.SUPL_CDPurchaseOrders.SUPLR_CDContract_Lines.SUPLR_CD
      Materials.MATRL_CDPO_Lines.MATRL_CDContract_Lines.MATRL_CD

       

      No issues with SUPLR_CD.

      But MATRL_CD is giving circular reference warning.

      If i disable/give unique name to MATRL_CD in "Contract_Lines" table, its not throwing the warning.

       

      I tried to split contract lines to two different tables by moving SUPLR_CD into CONTRACTS and MATRL_CD into CONTRACT_LINES but with no success.

       

      If I'm not specifying MATRL_CD in CONTRACT_LINES and renaming it, i dont understand how the contract lines would be picked for the selected material.

       

      Your help is much appreciated.

      Regards

      Ilyas