How to create a chart with multiple aggregation grouping?
This is my first app with Qlik. I am trying to create a chart where I can see the Hour of the day where I had the max Count. To calculate the max Count first I have to aggregate the Sum of count for each hour.
What kind of chart can be used to achieve this? Or How can I manipulate the data before using it in the chart?
My data looks like this. Here for example rows 2 to 6 contains the count for hour 8. I need to sum by hour and find the max for each date.
I would like to see an output something like this. Where the dot represent the hour of the day that has max count.