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?