topic Re: How to construct timeline in Qlikview that will look something similar to QS Timeline Extension Example in QlikView

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

vvira1316 — Wed, 30 Nov 2016 02:36:47 GMT

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

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

marcus_sommer — Wed, 30 Nov 2016 06:39:00 GMT

Maybe this is helpful:

Recipe for a Gantt chart

How to create a Gantt chart using a Pivot table

- Marcus

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

vvira1316 — Wed, 30 Nov 2016 23:38:33 GMT

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

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

vvira1316 — Thu, 01 Dec 2016 01:28:14 GMT

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])