AVG

[qlikview979]

Hi Experts,

please find the attachment, here i need average  from >4

Advanced Thanks

[MK_QSL]

Average with respect to what...?

What is the output you are looking for?

[sunny_talwar]

I guess Avg of the AVERAGE field where it is greater than 4 minutes?

[MK_QSL]

Load AVERAGE From FileName

Where Time(AVERAGE) >= Time#('00:04:00','hh:mm:ss');

[sunny_talwar · Accepted solution]

May be this?

Avg(If(AVERAGE > MakeTime(0, 4), AVERAGE))

[qlikview979]

Hi Manish,

sort the data "descending" and calculate the average from 0:05:00   to END-TIME.

[qlikview979]

Hi Sunny,

please share with my data.

sort the data "descending" and calculate the average from 0:05:00   to END-TIME(0:16:00)

ex:

calculate the    0:16:00 to 0:05:00

[qlikview979]

Hi Sunny,

your  condition is current   i got the exact output .

Thanks,

Mahesh.

[sunny_talwar]

So you won't need to me to create a sample for you then?

[qlikview979]

Hi,

No need to  create

Thanks,

Mahesh