topic issue with Calculated measure in QlikView

issue with Calculated measure

Wed, 28 Aug 2013 08:28:19 GMT

Hi ,

I have one calculated measure (Avg TAT) for that we are using below definition , and the final result will be in Hours ,

(((Sum(TOT_INTR_MIN*60)+sum(PPS_anr_tat_hrs__c*3600))/count(distinct(if(UPPER(Status)='CLOSED' or 'COMPLETED',Case_Number,1))))/3600)

TOT_INTR_MIN--> values are there in Minutes(so converted into Sec.)

PPS_anr_tat_hrs__c--> values are there in Hours (so converted into Sec.)

while using that definition not getting exact value(please look at below highlighted values in the table)

Can any one please help me here ?

Thanks & regards,

hic — Wed, 28 Aug 2013 08:31:14 GMT

You use the following condition, which isn't OK:

UPPER(Status)='CLOSED' or 'COMPLETED'

Change this to

Match(UPPER(Status),'CLOSED','COMPLETED')

HIC

Wed, 28 Aug 2013 08:50:43 GMT

Hi Henric,

Thanks for the reply , I tried that what you suggested but now also facing like same issue

Is there any other way to get the exact result 196.69----->197.09(expected result) ?

Thanks & Regards,