Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

When do households shop? Time of Day and Day of week

I need to be able to  do a graph which shows when households shop i.e. time of day and day of the week like the following graph portrays:

Screen Shot 2015-11-29 at 21.03.59.png

How can this be achieved in Qlikview.  I have attached an application with sample data for use. Thanking you in advance.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You have some good suggestions here. I've attached a sample qvw that creates the time buckets using mapping. I also experimented with visualizing the data as a heat map. as I think that could make a useful viz.

2015-11-29_23-45-17.jpg

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

14 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You don't seem to have time buckets in your data, so you will want to create those in the script based on the transaction time.

Then you can use a stacked bar chart with two dimensions: Weekday and TimeBucket.

As an alternative visualization, you may want to consider doing this a grid:

Pivot Table Grids | Qlikview Cookbook

-Rob

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Christopher

I need to know which field of your model represents the time to consider.

Eduardo

Anonymous
Not applicable
Author

Thanks Rob for your input

Anonymous
Not applicable
Author

Thank you Eduardo for your response.

[Date Dispensed] field has the time stamp for the transaction.

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Christopher

All data in the [Date Dispensed] field have the same time (12:00:00 AM). This field cannot be used to get the buckets from.

Eduardo

Anonymous
Not applicable
Author

Thanks Eduardo

I have managed to do the following:

Screen Shot 2015-11-29 at 23.39.40.png

Please see attached application.  However, i have the same values on the Y axis which is wrong.  Where am i getting it wrong?

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Christopher,

Your MasterCalendar table is linked to the [Main Data] table at the month level. As a consequence, every day of your [Main Data] is linked to every weekday (as all weekdays occur in a month).

Change the link between the [Main Data] and the MasterCalendar tables to the date level.

In the [Main Data] create the time buckets, as Rob suggested. After that, you can use both fields as dimensions(weekday and bucket)

Eduardo

Anonymous
Not applicable
Author

Hi Eduardo

Thank you very much i will do that and advise accordingly.

Regards.

MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_193357_Pic1.JPG

QlikCommunity_Thread_193357_Pic2.JPG

QlikCommunity_Thread_193357_Pic3.JPG

hope this helps

regards

Marco