Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

View solution in original post

2 Replies
Partner
Partner

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

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

View solution in original post