If statement with Set Analysis

[#1]

I have the following bit of Set Analysis in a Bar Chart:

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT CALL_NUMBER)

But I would like it to only apply if RESPONSE_TIME > TARGET_RESPONSE

Could anyone please help.

Many thanks

Paul

[alexandros17]

Try

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT

     if (RESPONSE_TIME > TARGET_RESPONSE, CALL_NUMBER, 0)

)

or

if (RESPONSE_TIME > TARGET_RESPONSE,

     Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>} DISTINCT CALL_NUMBER)

,0)

Let me know

[Gysbert_Wassenaar · Accepted solution]

You may have to use an if statement:

Count({1<ARRIVAL_DATE= {"$(=Date(Today(), 'DD/MM/YYYY'))" },AREA_GROUP -={'B'}>}DISTINCT

if( RESPONSE_TIME > TARGET_RESPONSE, CALL_NUMBER))

Doing a comparison between fields of the same record is not always possible. See this document: set_analysis_intra-record.qvw

[#4]

Many thanks, this one worked.

[SunilChauhan]

count({<RESPONSE_TIME={>$(=TARGET_RESPONSE)}>}CALL_NUMBER)

[#6]

Thanks for your help.