Line Chart - Timestamps

[#1]

I am trying to plot a line chart with timestamps. It should show the time on the Y-axis and the table headers on the X-axis. Is this possible?

The attached screenshot shows what I am trying to achieve. There is a separate table for SLA that should also be shown on the chart (green line in screenshot) so that it can be compared. Is this something that is do-able using the line chart in Qlikview? Or is there a better method to depict this?

[sunny_talwar]

Is this what you want?

[#3]

Yes! That looks exactly like what we are aiming for.

[sunny_talwar]

Fixed the axis to show only time as timestamp doesn't make sense here

[#5]

Is there also a possibility to overlay the SLA line (it would be fixed data as an in-line table in the script)?

[sunny_talwar · Accepted solution]

Like this?

[#7]

Yes, that works very well. Will look into the CrossTable function. Thanks!

[#8]

Is it possible to use the SLA line as a reference line so that it always shows?

[sunny_talwar]

Like this you mean?

[#10]

This seems to break however, when having multiple dates or if the time extends to the next day from SLA. The SLA should use the current selected date and not the date from past...any way to keep the date that was selected from the Phase with same times?