topic Re: If statement with Set Analysis in QlikView

If statement with Set Analysis

Fri, 09 May 2014 10:38:00 GMT

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 — Fri, 09 May 2014 10:41:52 GMT

Try

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

if (RESPONSE_TIME > TARGET_RESPONSE, CALL_NUMBER, 0)

)

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 — Fri, 09 May 2014 10:43:27 GMT

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

Fri, 09 May 2014 10:49:05 GMT

Many thanks, this one worked.

SunilChauhan — Fri, 09 May 2014 10:49:19 GMT

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

Fri, 09 May 2014 10:49:33 GMT

Thanks for your help.