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



      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