0 Replies Latest reply: May 19, 2017 5:05 PM by Sujit Gouda RSS

    Rolling 12M, 18M as Variables for Dashboards

    Sujit Gouda

      Hi,

      I am fairly new to QlikSense, well just 5 days in.

       

      I was able to create a Master Calendar with the following entries, and created the below variable inside of qlik sense for toggling between various Time Dimension. However I am failing miserably to build Rolling 12M and Rolling 18M.

       

      mastercalendar

       

      DateDim:

      LOAD Distinct

      "Transaction Date",

      Floor([Transaction Date]) AS DateNum,

      "Transaction Date" as Date,

      Month([Transaction Date]) as Month,

      Year([Transaction Date]) & 'Q' & Ceil(Num(Month([Transaction Date]))/3) as Quarter,

      Year([Transaction Date]) as Year,

      Year(addyears([Transaction Date],-1)) as Prior_Year,

      Week([Transaction Date]) as Week

       

       

      RESIDENT Transaction;

       

      Variable - vToDate with values "Year", "Month", "Week", "Date"

      and Corresponding calculation

       

      Sum({<Year=, Month=, Quarter=, Week=, Date=, DateNum={">=$(=Num($(=vToDate& 'Start(Max(DateNum))')))<=$(=Max(DateNum))"}>} [USD Inflows])

       

      How would I expand the use case to toggle btwn various other time dim.

       

      Please help.

      2017-05-19_17-05-02.png