issue with Master Calendar- Qlik Sense

[nagarajs]

I have 3 fact tables ( InvoiceGP and Orders).

Invoice GP has Invoice key, InvYear, InvMonth, InvDay, InvWeek

Orders has OrdersKey, OrdYear, OrdMonth, OrdDay, OrdWeek and is connected to OrderDetails  thru order control number

Invoice GP and Orders are connected to a linktable with the key as InvoiceGPInfoKey and OrdersKey

Linktable has both keys and other fields related to master files and Date

Master Calendar is linked to Linktable

Problem:

Data validation is accurate when we check based on InvYear for Invoices and OrdYear for Orders

Data validation is WRONG when we check based on Master Calendar Year

how to solve this

[Chanty4u]

chk dis

Qliksense Master Calender

[nagarajs]

thank you for the reply. I have the calendar connected . problem is this. the value see using InvYear ( correct) vs using Year ( wrong). I have a question . Im keeping 2 columns in link table ( 1 for orders) and 1 for Invoice . Does it need to be as a Key with both invoicekey and order key kept in the same column. pls comment