Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vb00494773
New Contributor III

How to convert time stamp into relative time

Hi Team,

Please help to convert the timestamp into relative time

below is the sample data:

date                                   value


11/14/2016 18:20:10.9601411262.667
11/14/2016 18:20:10.9701411279.167
11/14/2016 18:20:10.9801411295.667
11/14/2016 18:21:10.9901411312.167
11/14/2016 18:20:11.0001411328.667
11/14/2016 18:20:11.0101411345.167
11/14/2016 18:22:11.0201411361.667
11/14/2016 18:20:11.0301411378.167
11/14/2016 18:20:11.0401411394.667
11/14/2016 18:23:12.9801414381.167
11/14/2016 18:20:12.9901414397.667
11/14/2016 18:20:13.0001414414.167
11/14/2016 18:24:13.0101414430.667
11/14/2016 18:20:13.0201414447.167
11/14/2016 18:20:13.0301414463.667
11/14/2016 18:25:13.0401414480.167
11/14/2016 18:20:14.9801417549.167
11/14/2016 18:26:14.9901417565.667
11/14/2016 18:20:15.0001417582.167
11/14/2016 18:27:15.0101417598.667
11/14/2016 18:20:15.0201417615.167
11/14/2016 18:20:15.0401417631.667
11/14/2016 18:28:15.0501417648.167

Out put should be like below :

line.PNG

by using timestamp, i should get the x-axis as relative time (whole time stamp need to convert into seconds)

FYI, starting time stamp should be consider as 0 (zero) then 300 seconds need to add for the starting time like that it should go in x-axis .

(starting time - (minus ) next time difference in seconds need to add into the relative time .

Thanks,

Venkatesh