4 Replies Latest reply: Jun 3, 2014 3:13 PM by Rodrigo Lauro RSS

    Qlikview Conditional Expression - Summary

      I having trouble with a conditional expression in Pivot table.

      The expression is

      =Sum(if(REALIZED_DATE < date(max(REALIZED_DATE)) and GL_REALIZED_DATE > monthstart(addmonths(date(max(REALIZED_DATE))), -6, 1)), TRANSAMOUNT * -1, 0))

      I am trying to get a summary on transamount * -1 when the realize date in within six months of max realize date.

      Am I not allowed to use max within sum, if so is there a way i can load the max date into a parameter in script and use parameter for the coniditon.

       

      Appreciate your input.

       

      Thank you,

      Pad