Trend Over Time Line Graph

[#1]

Hi,

I'm trying to create a line graph to show a trend over time. I want to have the Actual Start Date as the X axis, and Actual Start Time as the Y, but only for the Runs found in both tables.

How can I do this; is it a problem that my Start Time / Date values are not standard:

Actual Start Time: HHMMSS

155712 = 15:57:12

1533 = 00:15:33

424 = 00:04:24

Actual Start Date: 1YYMMDD

1150602 = 02/06/2015

Scheduled Runs

Scheduled Runs

Name	Description	Scheduled Start Time	Scheduled End Time
Run1	ABC	153000	153005
Run2	123	235500	500
Run3	XYZ	900	1500
Run4	456	83000	83500

Actual Runs

Name	Status	Actual Start Time	Actual End Time	Actual Start Date	Actual End Date
Run1	C	155712	160146	1150603	1150602
Run1	C	194629	194821	1150603	1150602
Run1	F	202245	202512	1150602	1150602
Run2	F	235621	424	1150601	1150602
Run2	C	1533	1756	1150603	1150602
Run6	C	210002	210342	1150601	1150601
Run7	C	5626	10126	1150603	1150602

Any help would be really appreciated!

Kind regards,

Tristan

[Anonymous · Accepted solution]

Convert your time into true QlikView times.

You can paste the below into a Text Box and check it converts 424 correctly:

     =time(time#(text( num(424,'000000')),'hhmmss'),'hh:mm:ss')

Then test with some of your other times.

And finally use it with your actual data field :

     =time(time#(text( num([Actual Start Time],'000000')),'hhmmss'),'hh:mm:ss')

Similarly you can sort your dates with the date() and date#() functions which you can find details of in the QV Desktop Help.

[#3]

Thanks very much Bill, that's a great help. The Time part has worked correctly, so I'm scanning now for more date information.

Kind regards,

Tristan

[Anonymous]

Try something like this :

     = date ( date# ( mid ( '1150602' , 2 ) , 'YYMMDD' ) , 'DD/MM/YYYY' )