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

[Anonymous]

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:

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

[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]

Hi, Christopher

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

Eduardo

[Anonymous]

Thanks Rob for your input

[Anonymous]

Thank you Eduardo for your response.

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

[eduardo_sommer]

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]

Thanks Eduardo

I have managed to do the following:

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]

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]

Hi Eduardo

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

Regards.

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco