Bar Line Graph using Time Dimension

Thu, 20 Nov 2014 19:10:51 GMT

I need to create a bar line graph (2 y-axis) that is sourced from two data tables. I'm not sure of the best way relate them by a KeyField yet, so currently the KeyField is just store.

The application will require one input for date and one for store and only one date and store can be selected at a time.

Fields for Sales QVD include:

Sales, Date, Store, Start time, End time (time in hour of the day increments)

There may not be sales for every hour during any given day; not all stores are open 24 hrs

Fields for Labor QVD include:

EE Name, Date, Store, Start (timestamp), End (timestamp)

Questions:

How can I show sales by hour as a bar and number of employees working throughout the day?
How to always show a full day (24 hours) even if the store did not record sales from 12AM day 1 to 12 AM day 2.

My QVW attached has two charts. The bar line chart on the left is the chart in question. The Gantt chart (horizontal stacked) on the right is separate. It's a reference as to how many employees were in the store throughout the day.

Any help, suggestions and/or comments will be greatly appreciated. Thanks for your time.

Re: Bar Line Graph using Time Dimension

Anonymous — Thu, 20 Nov 2014 19:38:54 GMT

Use a Combo Chart with 2 expressions, one for Sales as Bars and the other for Employees as a Line.

On the Axes tab make the position of one expression Right and the other left.

On your time dimension I'd granualise to hours and tick Show All Values.

On Presentation tab untick Suppress Zero-Values and Suppress Missing.

On the Axes you may or may not need to tick Continuous.

topic Re: Bar Line Graph using Time Dimension in QlikView

Bar Line Graph using Time Dimension

Re: Bar Line Graph using Time Dimension