1 Reply Latest reply: Oct 5, 2018 4:33 PM by Mario Centeno RSS

    Get the last sale of the year in set analysis

    Mario Centeno

      Hello community I have the following challenge I want to get the last sale of the year in set analysis, I have an expression that adds the sales to the YTD but it is not the data I need, I want to obtain the utmost record of the accumulated sales.


      Value currently displayed  $35771,846



      The correct value is $10719408.

       

       

      Expression

       

      SUM({<[F_IFR.autoCalendar.Year]={'$(vMaxYear)'},F_IFR={'<=$(vMaxDate)'},

      [F_IFR.autoCalendar.Date]=,[F_IFR.autoCalendar.Date]=,[F_IFR.autoCalendar.YearMonth]=>}REAL_ACUM)

       

       

      QLIK.png