Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siva_boggarapu
Contributor II

Best data model in Qlik sense

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?

3 Replies
zebhashmi
Valued Contributor

Re: Best data model in Qlik sense

Digvijay_Singh
Honored Contributor III

Re: Best data model in Qlik sense

Can you remove mapping between receiptheader and FranConnect?

They are connected through StoreID. Even if you remove that mapping, you will have storeID information through your other link. Just a thought!

YoussefBelloum
Esteemed Contributor

Re: Best data model in Qlik sense

one solution would be to:

join the fields you need from DiscountCodeMap to ReceiptDiscount

and join the fields you need from DiscountCodeMap to FranConnect

rename the common fields to not make a join between ReceiptDiscount and FranConnect

Community Browser