2 Replies Latest reply: Mar 25, 2016 12:30 PM by Nagaraj Shanmugam RSS

    issue with Master Calendar- Qlik Sense

    Nagaraj Shanmugam

      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