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