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)



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





      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 ?