Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregating Purchases by Hour and Day

Hello --

I am working through a problem and having some difficulty getting the result I am looking for.

Below is a simple table of what I am trying to achieve.

Merchandise DivisionHourDayHour (All)Day (All)
Apparel10Mon8Tues
Accessories15Tues8Tues
Cosmetics17Tues8Tues
Electronics9Sun8Tues

What I am looking for here is the top number of sales by hour and day per listed merchandise division. The goal would be to sum the orders by hour and day and output the hour and day which had the highest number of sales per division. I would also like to list the top hour across all division and days within the table as well.

I've tried a few set analyses but I think what I am trying to achieve is a bit more robust then I can handle.

Any thoughts on how one might achieve this?

Best,

Dan

4 Replies
Not applicable
Author

!Hello -

I am attaching a small data set in Excel which may help with understanding the inputs I am working with.

Thanks,

Dan

kkkumar82
Specialist III
Specialist III

Check the attached

kkkumar82
Specialist III
Specialist III

aggrComm.png

Not applicable
Author

Hi,

Thanks for the reply.

Is there a way to just return the highest value per division.

For example, the Accessories category has the most revenue during hour 4... I would then want to see what day has the highest revenue regardless of the hour. So the accessories table may look like this:

DivisionTop Order HourTop Order DayIn All Division / HourIn All Division / Day
Accessories4Tuesday?10?Wednesday?

I guess this could be achieved by a sort using what you provided.

Thanks for the help!

Dan