0 Replies Latest reply: Aug 9, 2013 2:21 AM by Paul Scotchford RSS

    Get Last Year values based on user date selection

    Paul Scotchford
      Hi All
      This may have already been answered elsewhere but my searches seem to not pick up a suitable answer and
      pleae forgive my newness to QV and Set Analysis.
      I want to show Sales This Year (2013) and Last Year (2012)
      Now, when the user selects 1 Aug 2013 I want to show on the chart 1 Aug 2013 and 1 Aug 2012 then          (This Works fine )
                               user selects    Aug 2013 I want to show on the chart    Aug 2013 and    Aug 2012 then          (This works too  )
                               user selects            2013 I want to show on the chart           2013 and           2012                  ( Shows All 2013 but persists Aug 2012)
      I have tried various combinations of my set analysis but just cant get the correct Aggregation part , the user
      sees current year , but the Aug 2012 persists.
      Here's a sample of my set analysis ( not original I sourced it from another blog post here )
      Many thanks in advance for any feedback.
      {$<MonthID = {$(=Max(MonthID) - 12)},
      Date = {"<=$(=Date(MakeDate(Max(Year) - 1, Max([Month (#)]), Day(Max(SaleDate))),'YYYY-MM-DD'))"},
      Year = {$(=Max(Year)-1)},
      Quarter = ,
      Period = ,
      [Period (#)] = ,
      Month = >}