2 Replies Latest reply: Jul 3, 2017 11:39 PM by Pankaj Thakur RSS

    how to see values in 0 ?

    Alvaro Garcia

      Hi everyone, I'm going to tell you my problem.

       

       

      I have in my application data this design:

       

      Sales = FactTable (Current date)

      Meta = Sales Goals (Estimate)

      Forecast = Sales Forecast (Estimate)

      datawahouse.PNG

       

      My problem is, I can not see my Meta if I do not have data in Ventas table to the same period.

       

       

      Eg:

       

      Table Ventas have data between 2017-Jan and 2017-May

       

      Table Meta have data Between 2017-Jan and 2017-Dec

       

      If i want to see Meta in 2017-Oct i can not do that because i need more information in FactTable until 2017-Oct as minimun.

       

      After saw that problem, i decide to charge dummy data in FactTable with all values in zero to bypass this problem, but for some reason Qlik Sense still blocking me.

       

      Anyone know how i can see the Meta ?