topic Re: create bar chart with source system start time, end time and target system start time, end time with difference of Source system end time and target system start time based on country_code in QlikView https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058903#M930618 <HTML><HEAD></HEAD><BODY><P>Did you check the solution posted? please close the thread by selecting correct, helpful answers or post questions in case you need more help from community.</P></BODY></HTML> Fri, 18 Mar 2016 07:43:11 GMT Digvijay_Singh 2016-03-18T07:43:11Z create bar chart with source system start time, end time and target system start time, end time with difference of Source system end time and target system start time based on country_code https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058900#M930615 <HTML><HEAD></HEAD><BODY><P>I would like to show the data below in stacked bar graph.</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 647px;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">CTRY_CD</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">REGION</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">SRC_STRT_TIME</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">SRC_END_TIME</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">TGT_START_TIME</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">TGT_END_TIME</TH></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AR</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 13:55:11</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:09:28</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:20:08</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">BR</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:09:30</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:51:45</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:48:53</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">CA</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 13:55:11</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:37:38</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 04:00:51</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 04:11:36</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">CL</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:36:08</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:43:21</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:09:11</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">VE</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:33:59</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:43:19</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:59</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:15:11</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">EC</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:37:39</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:47:52</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:15:13</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">MX</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 13:55:11</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:36:06</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:56:57</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">PE</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:23:49</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:33:57</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:15:01</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">PY</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:43:21</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:48:54</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:58</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:05:00</TD></TR><TR><TD height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">CO</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">AMERICAS</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 13:55:11</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">09-MAR-16 14:10:42</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:00:59</TD><TD style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10-MAR-16 01:22:02</TD></TR></TBODY></TABLE><P></P><P>Thanks</P><P>Raj</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058900#M930615 2020-11-25T16:16:04Z Re: create bar chart with source system start time, end time and target system start time, end time with difference of Source system end time and target system start time based on country_code https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058901#M930616 <HTML><HEAD></HEAD><BODY><P>See attached -</P></BODY></HTML> Sat, 12 Mar 2016 16:25:51 GMT https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058901#M930616 Digvijay_Singh 2016-03-12T16:25:51Z Re: create bar chart with source system start time, end time and target system start time, end time with difference of Source system end time and target system start time based on country_code https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058902#M930617 <HTML><HEAD></HEAD><BODY><P>please specify your expected result.</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 12 Mar 2016 21:57:47 GMT https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058902#M930617 MarcoWedel 2016-03-12T21:57:47Z Re: create bar chart with source system start time, end time and target system start time, end time with difference of Source system end time and target system start time based on country_code https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058903#M930618 <HTML><HEAD></HEAD><BODY><P>Did you check the solution posted? please close the thread by selecting correct, helpful answers or post questions in case you need more help from community.</P></BODY></HTML> Fri, 18 Mar 2016 07:43:11 GMT https://community.qlik.com/t5/QlikView/create-bar-chart-with-source-system-start-time-end-time-and/m-p/1058903#M930618 Digvijay_Singh 2016-03-18T07:43:11Z