topic Avg between two timestamps in QlikView

Avg between two timestamps

Fri, 17 Jul 2015 15:48:58 GMT

Hello,

I'm trying to get the average of a column between certain time, 7-7:30 am for this one:

=Avg({<Time(CreateTimestamp,'hh:mm')={">='07:00')<='07:30'"}>}[Total Time])

Something is wrong here, not sure what. Thanks in Advance

sunny_talwar — Fri, 17 Jul 2015 15:50:36 GMT

Try this:

=Avg({<CreateTimestamp={"=Time(CreateTimestamp,'hh:mm') >='07:00') and Time(CreateTimestamp,'hh:mm') <='07:30'"}>}[Total Time])

Not 100% sure if it will work, but I feel it should work.

Qrishna — Fri, 17 Jul 2015 16:58:30 GMT

See Attached.

it shows how you can calculate Avg(RandomData) for a Time Range.

Hope that helps.

Krishna.

maxgro — Sun, 19 Jul 2015 13:23:49 GMT

=Avg(if(frac(timestamp)>=7/24 and frac(timestamp)<=7.5/24, frac(timestamp)))

then format the expression result in number tab (time)