Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Thanks for the response Gabriela. I still couldn't get this to work so I just decided to create a "flag" in the script
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!
Thanks for the response Gabriela. I still couldn't get this to work so I just decided to create a "flag" in the script