topic Re: Re: Point in time charts in QlikView

Point in time charts

Thu, 29 May 2014 09:00:13 GMT

I create some point in time charts based on time rather than date .

I have various objects that has 5 stages, (Stage 1,2,3,4 and 5) that is needs to go through and each of these stages have a time stamp when acheived what I want to plot if possible is a stacked bar chart which shows the stages the object has passed through against the timeline

the axis I want are

Object Name

time (e.g current time plus or minus 1 hr)

with the stage values displayed as a stacked bar chart (grouped by object Name)

Hope this makes sense

Re: Point in time charts

Thu, 29 May 2014 12:08:54 GMT

Sue,

Is your data model ready?

Do you have 5 columns for stagetimes, like: stage1_time, stage2_time, ....

or rather 5 rows for each object with stage_number and time fields?

regards

Darek

Re: Point in time charts

Thu, 29 May 2014 12:12:39 GMT

The current data is set up as the later so rows for each object with stage_number and time fields

But I am currently working on producing a demo so can easily change this if this is a better way of working

Re: Re: Point in time charts

Thu, 29 May 2014 12:29:21 GMT

Sue,

here is example for you with both data models.

regards

Darek