Dynamic Set Modifier - Expression assistance needed please

[#1]

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)

[gmoraleswit]

Hi,

First you need to create a new field for the month of 'RC_Detected_On_Date', you have to do this on the script, example:

Load ...

     Month(RC_Detected_On_Date) as Detected_On_Month

     ...

from ...

Once you have the new field, you can use set analysis, so your expression would be something like this:

Count({<Detected_On_Month={"<=$(=max(RC_Month))"}>} RC_Defect_ID)

Hope this helps

Regards!

[#3 · Accepted solution]

Thanks for the response Gabriela. I still couldn't get this to work so I just decided to create a "flag" in the script