Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

AVG

Hi Experts,

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

Advanced Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this?

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

View solution in original post

9 Replies
MK_QSL
MVP
MVP

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
MVP
MVP

Load AVERAGE From FileName

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

sunny_talwar

May be this?

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

View solution in original post

qlikview979
Specialist
Specialist
Author

Hi Manish,

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

qlikview979
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

Hi,

No need to  create

Thanks,

Mahesh