Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Dynamic Set Modifier - Expression assistance needed please

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)

1 Solution

Accepted Solutions
Not applicable

Re: Dynamic Set Modifier - Expression assistance needed please

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

2 Replies
gmoraleswit
Contributor II

Re: Dynamic Set Modifier - Expression assistance needed please

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!

Not applicable

Re: Dynamic Set Modifier - Expression assistance needed please

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