Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Re: Aggregating Purchases by Hour and Day

!Hello -

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

Thanks,

Dan

kkkumar82
Valued Contributor III

Re: Aggregating Purchases by Hour and Day

Check the attached

kkkumar82
Valued Contributor III

Re: Aggregating Purchases by Hour and Day

aggrComm.png

Not applicable

Re: Aggregating Purchases by Hour and Day

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