topic Re: Dynamic Set Modifier - Expression assistance needed please in QlikView

Dynamic Set Modifier - Expression assistance needed please

Wed, 03 Sep 2014 16:07:43 GMT

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)

Re: Dynamic Set Modifier - Expression assistance needed please

gmoraleswit — Wed, 03 Sep 2014 17:28:07 GMT

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!

Re: Dynamic Set Modifier - Expression assistance needed please

Mon, 15 Sep 2014 21:02:39 GMT

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