How to construct timeline in Qlikview that will look something similar to QS Timeline Extension Example

[vvira1316]

Hi,

How to construct a timeline from following information that is calculated using expression and formula. It will be really nice if timeline will look something similar like following example from QS.

Qliksense timeline example can be found here GitHub - ralfbecher/QlikSense_Extension_Timeline: QlikSense Extension Timeline

Edit DateTime	CP Doc: DocID	Edit Date	Edit Time	Field / Event	New Value	Old Value
42671.629861111	451434	10/28/2016	3:07:00 PM	DocStatus	ED sent to customer	TBD-PC
42558.45	451434	07/07/2016	10:48:00 AM	DocStatus	TBD-PC	TBD
42438.663888889	451434	03/09/2016	3:56:00 PM	DocStatus	TBD	NR
42438.579166667	451434	03/09/2016	1:54:00 PM	Created.	-	-

=MaxString({<[CP Doc: DocID]={'451434'}, [Field / Event]={'Created.'}>}[Edit Date Time])

=MaxString({<[CP Doc: DocID]={'451434'}, [Field / Event]={'DocStatus'}, [New Value]={'TBD'}>}[Edit Date Time])

=MaxString({<[CP Doc: DocID]={'451434'}, [Field / Event]={'DocStatus'}, [New Value]={'TBD-PC'}>}[Edit Date Time])

=MaxString({<[CP Doc: DocID]={'451434'}, [Field / Event]={'DocStatus'}, [New Value]={'ED sent to customer'}>}[Edit Date Time])

Time difference is calculated using expression included above in a calculation formula.

Screenshot from QS Sample

I will appreciate any help/guidance.

Thanks,

Vijay

[marcus_sommer]

Maybe this is helpful:

Recipe for a Gantt chart

How to create a Gantt chart using a Pivot table

- Marcus

[vvira1316]

Hi Marcus,

Thanks for pointing to useful information. I'm able to leverage and use it. I'm having some challenge in getting offset work correctly for each Event. I'm getting the right offset value that I want to use and I'm displaying it in each bar as can be seen in the screenshot.

I'll appreciate pointers.

Best Regards,

Vijay

[vvira1316]

I found the issue in the expression. I had to change it to

=Max({<[TL Event]>}[TL End Date Time]) - Max({<[TL Event]>}[TL Start Date Time])

and not

=Max({<[TL Event]>}[TL Start Date Time]) - Max({<[TL Event]>}[TL End Date Time])