topic Re: Line Chart - Timestamps in QlikView https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274588#M400504 <HTML><HEAD></HEAD><BODY><P>Yes, that works very well. Will look into the CrossTable function. Thanks!</P></BODY></HTML> Fri, 16 Dec 2016 17:15:24 GMT 2016-12-16T17:15:24Z Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274582#M400498 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>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?</P></BODY></HTML> Fri, 16 Dec 2016 16:05:44 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274582#M400498 2016-12-16T16:05:44Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274583#M400499 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146901_Capture.PNG" style="height: 237px; width: 620px;" /></P></BODY></HTML> Fri, 16 Dec 2016 16:59:59 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274583#M400499 sunny_talwar 2016-12-16T16:59:59Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274584#M400500 <HTML><HEAD></HEAD><BODY><P>Yes! That looks exactly like what we are aiming for.</P></BODY></HTML> Fri, 16 Dec 2016 17:04:28 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274584#M400500 2016-12-16T17:04:28Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274585#M400501 <HTML><HEAD></HEAD><BODY><P>Fixed the axis to show only time as timestamp doesn't make sense here</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146902_Capture.PNG" style="height: 233px; width: 620px;" /></P></BODY></HTML> Fri, 16 Dec 2016 17:06:38 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274585#M400501 sunny_talwar 2016-12-16T17:06:38Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274586#M400502 <HTML><HEAD></HEAD><BODY><P>Is there also a possibility to overlay the SLA line (it would be fixed data as an in-line table in the script)?</P></BODY></HTML> Fri, 16 Dec 2016 17:07:25 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274586#M400502 2016-12-16T17:07:25Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274587#M400503 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146906_Capture.PNG" style="height: 264px; width: 620px;" /></P></BODY></HTML> Fri, 16 Dec 2016 17:09:51 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274587#M400503 sunny_talwar 2016-12-16T17:09:51Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274588#M400504 <HTML><HEAD></HEAD><BODY><P>Yes, that works very well. Will look into the CrossTable function. Thanks!</P></BODY></HTML> Fri, 16 Dec 2016 17:15:24 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274588#M400504 2016-12-16T17:15:24Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274589#M400505 <HTML><HEAD></HEAD><BODY><P>Is it possible to use the SLA line as a reference line so that it always shows?</P></BODY></HTML> Fri, 16 Dec 2016 19:45:58 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274589#M400505 2016-12-16T19:45:58Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274590#M400506 <HTML><HEAD></HEAD><BODY><P>Like this you mean?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146912_Capture.PNG" style="height: 215px; width: 620px;" /></P></BODY></HTML> Fri, 16 Dec 2016 19:49:07 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274590#M400506 sunny_talwar 2016-12-16T19:49:07Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274591#M400507 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Fri, 16 Dec 2016 20:01:03 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274591#M400507 2016-12-16T20:01:03Z Re: Line Chart - Timestamps https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274592#M400508 <HTML><HEAD></HEAD><BODY><P>A table with SLA times can be made but seems redundant.</P></BODY></HTML> Thu, 22 Dec 2016 15:36:59 GMT https://community.qlik.com/t5/QlikView/Line-Chart-Timestamps/m-p/1274592#M400508 2016-12-22T15:36:59Z