topic Average TAT in QlikView

Average TAT

Wed, 01 Oct 2014 12:47:07 GMT

Hi All,

I need to calculate the Average of for (Payment_Sent_Date - LDR ) as shown in image. How can i calculate Average of Days between Payment_sent_date and LDR. From Given Snapshot Average should be as (1+2+1+2+0+1+1+2+2)/9 from No_Of_Days field.

Kindly Reply

Re: Average TAT

Gysbert_Wassenaar — Wed, 01 Oct 2014 12:59:42 GMT

avg(No_Of_Days) would be my guess.

Re: Average TAT

Wed, 01 Oct 2014 13:08:55 GMT

Depends on what you want.

AVG(No_Of_Days) to calculate the average over all records

or Avg(Aggr( AVG(No_Of_Days),Contract_number)) to calculate the average you seem to want.

This aggregates the values per Contract_number and then calculates the average.

AVG(No_Of_Days) will give you (28*0 + 96*1 + 96*2)/(28+96+96) or if you look at it from the Contract_number 24*1 + 24*2 + 24*1 + ... etc.