topic Re: How to show a line chart with two dimensions with different expressions? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122974#M522481 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>front end solution could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_217880_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125486_QlikCommunity_Thread_217880_Pic1.JPG" style="height: 244px; width: 620px;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_217880_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/125487_QlikCommunity_Thread_217880_Pic2.JPG" style="height: 395px; width: 620px;" /></P><P></P><P>or</P><P><IMG alt="QlikCommunity_Thread_217880_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/125488_QlikCommunity_Thread_217880_Pic3.JPG" style="height: 241px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_217880_Pic4.JPG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/125489_QlikCommunity_Thread_217880_Pic4.JPG" style="height: 141px; width: 620px;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_217880_Pic5.JPG" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/125490_QlikCommunity_Thread_217880_Pic5.JPG" style="height: 510px; width: 620px;" /></P><P></P><P>but I would suggest to use the calculated dimension expressions in the script to generate additional fields you could use in the charts instead.</P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 23 May 2016 22:48:22 GMT MarcoWedel 2016-05-23T22:48:22Z How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122970#M522477 <HTML><HEAD></HEAD><BODY><P>In a line chart, I want to show the production values for two different periods. What is the best way to realize this?</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125384_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 23 May 2016 09:20:28 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122970#M522477 rennesia 2016-05-23T09:20:28Z Re: How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122971#M522478 <HTML><HEAD></HEAD><BODY><P>Use if statement in the background color</P><P></P><P><STRONG>If(Dim2 = 'XYZ', Yellow(), Blue())</STRONG></P></BODY></HTML> Mon, 23 May 2016 13:38:57 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122971#M522478 sunny_talwar 2016-05-23T13:38:57Z Re: How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122972#M522479 <HTML><HEAD></HEAD><BODY><P>The color isn't the problem... How to show the second line with a different timestamp?</P></BODY></HTML> Mon, 23 May 2016 13:45:48 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122972#M522479 rennesia 2016-05-23T13:45:48Z Re: How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122973#M522480 <HTML><HEAD></HEAD><BODY><P>May be like this as your calculated dimension</P><P></P><P><STRONG>Dual(Date &amp; Chr(10) &amp; AddYear(Date, -1), Date)</STRONG></P></BODY></HTML> Mon, 23 May 2016 15:25:38 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122973#M522480 sunny_talwar 2016-05-23T15:25:38Z Re: How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122974#M522481 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>front end solution could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_217880_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125486_QlikCommunity_Thread_217880_Pic1.JPG" style="height: 244px; width: 620px;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_217880_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/125487_QlikCommunity_Thread_217880_Pic2.JPG" style="height: 395px; width: 620px;" /></P><P></P><P>or</P><P><IMG alt="QlikCommunity_Thread_217880_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/125488_QlikCommunity_Thread_217880_Pic3.JPG" style="height: 241px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_217880_Pic4.JPG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/125489_QlikCommunity_Thread_217880_Pic4.JPG" style="height: 141px; width: 620px;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_217880_Pic5.JPG" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/125490_QlikCommunity_Thread_217880_Pic5.JPG" style="height: 510px; width: 620px;" /></P><P></P><P>but I would suggest to use the calculated dimension expressions in the script to generate additional fields you could use in the charts instead.</P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 23 May 2016 22:48:22 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122974#M522481 MarcoWedel 2016-05-23T22:48:22Z Re: How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122975#M522482 <HTML><HEAD></HEAD><BODY><P>Thanks Marco for your examples. They are helpful for my problem, but not the complete solution. The two dates belong to two different (independent) fields, with a selection for both fields... </P><P></P><P><STRONG>A_Timestamp&nbsp;&nbsp;&nbsp;&nbsp; A_Percentage </STRONG></P><P>18-04-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54.6<BR />19-04-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 76.4</P><P></P><P><STRONG>B_Timestamp&nbsp;&nbsp;&nbsp;&nbsp; B_Percentage</STRONG><BR />20-05-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.4<BR />21-05-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54.3<BR />22-05-2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 65.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 24 May 2016 09:00:04 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122975#M522482 rennesia 2016-05-24T09:00:04Z Re: How to show a line chart with two dimensions with different expressions? https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122976#M522483 <HTML><HEAD></HEAD><BODY><P>Thanks for your answer, but my problem is unfortunately more difficult. See below...</P></BODY></HTML> Tue, 24 May 2016 09:01:14 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-line-chart-with-two-dimensions-with-different/m-p/1122976#M522483 rennesia 2016-05-24T09:01:14Z