topic issue with Master Calendar- Qlik Sense in App Development

issue with Master Calendar- Qlik Sense

nagarajs — Fri, 25 Mar 2016 15:37:59 GMT

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

Re: issue with Master Calendar- Qlik Sense

Chanty4u — Fri, 25 Mar 2016 16:16:46 GMT

chk dis

Qliksense Master Calender

Re: issue with Master Calendar- Qlik Sense

nagarajs — Fri, 25 Mar 2016 16:30:26 GMT

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