2 Replies Latest reply: Sep 15, 2014 5:02 PM by Josh Fortner RSS

    Dynamic Set Modifier - Expression assistance needed please

    Josh Fortner

      I'm still trying to understand the QlikView syntax, so this may seem simple to most. I need for the below expression to COUNT the Defect ID WHEN the MONTH of the Detected On Date is <= the Month+3. This expression is written within a chart. What I have written below should help you understand what I'm trying to achieve, but what is written below does not work.


      Any help is appreciated.


      Count({<Num(Month(RC_Detected_On_Date))<=(Num(RC_Month)+3)>} RC_Defect_ID)