Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
chitemerere
Specialist
Specialist

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

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

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

chitemerere
Specialist
Specialist
Author

Thanks Rob for your input

chitemerere
Specialist
Specialist
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

chitemerere
Specialist
Specialist
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

chitemerere
Specialist
Specialist
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