topic Re: AVG in QlikView

AVG

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Advanced Thanks

MK_QSL — Wed, 27 Apr 2016 11:20:41 GMT

Average with respect to what...?

What is the output you are looking for?

sunny_talwar — Wed, 27 Apr 2016 11:23:58 GMT

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

MK_QSL — Wed, 27 Apr 2016 11:25:28 GMT

Load AVERAGE From FileName

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

sunny_talwar — Wed, 27 Apr 2016 11:25:46 GMT

May be this?

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

qlikview979 — Wed, 27 Apr 2016 11:38:05 GMT

Hi Manish,

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

qlikview979 — Wed, 27 Apr 2016 11:40:30 GMT

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 — Wed, 27 Apr 2016 11:48:00 GMT

Hi Sunny,

your condition is current i got the exact output .

Thanks,

Mahesh.

sunny_talwar — Wed, 27 Apr 2016 11:56:22 GMT

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

qlikview979 — Wed, 27 Apr 2016 13:15:28 GMT

Hi,

No need to create

Thanks,

Mahesh