5 Replies Latest reply: Oct 29, 2014 3:59 AM by qlikview developer RSS

    Forecast with current date

    qlikview developer

      Hi all!

      I have value SALES - it is Fact.

      I want calculated SALES_forecact on another day.

      I want use this formula SALES_forecast = day(1-31 for example January) * SALES/ count(day this month)

      SALES for example 100

      If am choose 15 day in January i have 100*15/31

      If am choose 28 day in Marth i have 100 * 20/31

       

      Why can help me