6 Replies Latest reply: Dec 2, 2016 10:12 PM by Sunny Talwar RSS

    Prognosis calculation in Qlik Sense

    Ali Ahmad

      Hey guys.

       

      So I have a budget table with:

       

      BudgetDate

      Actual

      Budget

      DayThisWeek

      WeekDay

      DayThisMonth

       

      In a different table I have "PaidOutAmount"

       

      What I am trying to do is calculate a prognosis based on dividing Sum of PaidOutAmount by the # of day this month and then multiply by the Max Amount of Days This Month.

       

      Here is a picture of the Budget Table:

       

      budg.JPG

       

      So for today (02.2012.2016) it would be:

       

      (Sum(PaidOutAmonut) / (Value which is on that row from "DagDenneMåneden"))

       

      *

      Max(DagDenneMåneden) - (Value which is the highest this month from "DagDenneMåneden)


      Now what I am trying to understand is how can I get the value which is on the row in "DagDenneMåneden" from Todays date so that the prognosis grows as this increases? Monday the value would 3 instead of 2 and prognosis would be adjusted accordingly.


      Suggestions?