Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

nagarajs
New Contributor

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
sureshqv
Esteemed Contributor III

Re: issue with Master Calendar- Qlik Sense

nagarajs
New Contributor

Re: issue with Master Calendar- Qlik Sense

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

Community Browser