5 Replies Latest reply: Jun 23, 2016 8:58 PM by Darmawan Suria RSS

    12 months Trend for Max Transaction

    Darmawan Suria

      Hello everybody,


      I have a problem, why my 12 months Trend Line only show 1 month value when I select a Year_month in QlikSense?

       

      This is my Measure : Max(Aggr(sum({$<YEAR_MONTH_W = {">=$(=date(addmonths(max(YEAR_MONTH_W), -12), 'YYYY-MM'))"} * {"<=$(=max(YEAR_MONTH_W))"}>}TOT_TRANS),TANGGAL)).


      If I don't select any Year_month, the Trend line is OK.


      12 Months Trend Line Case.jpg


      Best Regards

      Dmw