Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Average

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?

3 Replies
MK_QSL
MVP
MVP

=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.

Not applicable
Author

Hi,

You can try like this.

Dimension: Hour

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

jyothish8807
Master II
Master II

Hi Tumelo,

PFA.

Hope it helps.

Regards

KC

Best Regards,
KC