9 Replies Latest reply: Oct 19, 2015 10:58 AM by Asim Lilani RSS

    Circular reference in purchase and sale orders

      Hello

       

      I am new in Qlik Sense and in this forum,

       

      I have this situation:

       

      I need to compare sales and purchases orders by product in a time periods (years, months)

       

      I have a table with

      Sales:

      OrderID,

      ProductID,

      SalesDate,

      ....

       

      Purchases:

      PurchaseOrderID,

      ProductID,

      PurchaseDate,

      ....

       

      I have two Calendar tables (with resident option) and in both of then I have a field Year to try to compare sales and purchases.

       

      However I have a circular reference, I can I resolve it?

       

      Thanks,