Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarajs
Partner - Contributor II
Partner - Contributor II

issue with Master Calendar- Qlik Sense

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

2 Replies
Chanty4u
MVP
MVP

nagarajs
Partner - Contributor II
Partner - Contributor II
Author

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