7 Replies Latest reply: Feb 21, 2013 9:52 AM by philbennettzo RSS

    How do I get the current MonthYear on a chart?

      I attended the Qlikview developer training last week and have been having a play with the file we created. However I am having trouble trying to get the current MonthYear on a chart.
      
      We added the master calendar at the training so the script should be ok.
      
      I can get it to work for just the year, so if I use the expression:
      
      sum({$<Year = {$(=max(Year))}>}LineSalesAmount)
      
      it works fine.
      
      However if I use the expression:
      
      sum({$<MonthYear = {$(=max(MonthYear))}>}LineSalesAmount)
      
      then the chart goes blank.
      
      What am I doing wrong?