Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Author

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
gmoraleswit
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
Author

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