10 Replies Latest reply: Mar 3, 2015 9:24 PM by James Kerrigan RSS

    How do I create a Year to Date Measure?

    James Kerrigan

      Hi guys,

       

      I'm trying to make a couple of Year To Date measures (Month Target & Month Actual) but I'm not sure how to do this. The YTD should be starting from July in the year selected.

       

      For years I use the field 'Financial Year', for months I use 'Period' (starts in July), and the measures are 'Month Target' and 'Month Actual'.

       

      There is another field 'MonthYear' which I am able to use if it's easier eg. August in 2012/13 is 'Aug-12', while August in 2013/14 is 'Aug-13'

       

      If anyone is able to help me solve this that would be amazing!

       

      Thanks in advance.

       

      Edit:

       

      To further explain, I basically want to do what I can do on Excel, but in Qlik Sense.

       

      qliksense example.png

       

      So I'm able to select 2013/14, and then select November, and the amount showing is 670.

       

      Does anyone know how I'm able to do this?