3 Replies Latest reply: Mar 16, 2018 11:20 AM by youssef belloum RSS

    Best data model in Qlik sense

    Siva Boggarapu

      Hi All,

       

      Please look at the attachment. Three tables Discountcodemap, ReceiptDiscounts and Franconnect form a circular reference.

       

      I want to create composite keys in Discountcodemap.

       

      I want to to create two keys in  Discountcodemap(Discountcode and Alignment_DMA) and it is connected two Franconnect (Alignment_DMA)


      This is making me circular reference and I use the statement in my script

       

      Loosen table Discountmap.

       

      But after loading the data it was making two red dotted lines.

       

      How to follow best data mode in this scenario?