Discussion Board for collaboration related to QlikView App Development.
please find the attachment, here i need average from >4
May be this?
Avg(If(AVERAGE > MakeTime(0, 4), AVERAGE))
View solution in original post
Average with respect to what...?
What is the output you are looking for?
I guess Avg of the AVERAGE field where it is greater than 4 minutes?
Load AVERAGE From FileName
Where Time(AVERAGE) >= Time#('00:04:00','hh:mm:ss');
sort the data "descending" and calculate the average from 0:05:00 to END-TIME.
please share with my data.
sort the data "descending" and calculate the average from 0:05:00 to END-TIME(0:16:00)
calculate the 0:16:00 to 0:05:00
your condition is current i got the exact output .
So you won't need to me to create a sample for you then?
No need to create