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.
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:
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?
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)