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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Peak count per day

I've got a call log (datetime, phone#) and have a request to show the day and hour with the most calls.

It's easy enough to get the count of calls per hour (dim Date, dim Hour, exp count(PHONE)) but I'm stumped as to how to show the date, hour of the day with max phone calls, max phone calls.

I can show the dim Date and the aggr(max(aggr(count(PHONE), HOUR, DATE)), DATE) which shows the date and the max calls for the day, but I'm having no luck also returning the Hour as a dimension.

Any help would be appreciated.

0 Replies