topic Re: Calculating Average in QlikView

Calculating Average

Wed, 18 Mar 2015 05:35:42 GMT

Hi All

I have two fields, [Number of People in Building] (Numeric) and [Hour] (00:00 - 23:00) respectively.

I would now like to calculate which hour of the day has the most number of people in the building on an average.

How can I do this?

MK_QSL — Wed, 18 Mar 2015 07:41:08 GMT

=Max(Aggr(SUM( [Number of People in Building]),Hour))

This will give you Max Number of People on any hour

=FirstSortedValue(Hour, -Aggr(SUM( [Number of People in Building]),Hour))

This will give you Hour when the Number of People are Maximum compare to all Hour.

Wed, 18 Mar 2015 07:54:35 GMT

Hi,

You can try like this.

Dimension: Hour

Expression: Avg( [Number of People in Building])

jyothish8807 — Wed, 18 Mar 2015 08:05:45 GMT

Hi Tumelo,

PFA.

Hope it helps.

Regards