topic Re: Scatter Chart in QlikView https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88534#M509617 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe one solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_318316_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217333_QlikCommunity_Thread_318316_Pic1.JPG" style="height: 353px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 01 Nov 2018 22:37:56 GMT MarcoWedel 2018-11-01T22:37:56Z Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88532#M509615 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two scatter charts, one showing the data for 2017 and the other one for 2018.</P><P></P><P>Dimension: Product Group (Values: A,B,C,D)</P><P>Expressions : 1. No of Quotes Approved&nbsp;&nbsp; 2. Units Requested</P><P></P><P>If 2018 is compared with 2017, Product A and D are growing , Product B is declining and for Product C one of the value is going up while the other is going down.</P><P></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 603px; height: 88px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">Product</TD><TD style="padding: 2px;">2017</TD><TD style="padding: 2px;">2018</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">81 (no. of quotes), 19000 (units requested)</TD><TD style="padding: 2px;">124, 45000</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">220, 44000</TD><TD style="padding: 2px;">200, 10000</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">950, 78000</TD><TD style="padding: 2px;">990, 55000</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">1330, 225300</TD><TD style="padding: 2px;">1350, 344000</TD></TR></TBODY></TABLE><P></P><P>I want my chart to show the data for 2017 and display colored arrows depending on whether the product is growing or declining in 2018.</P><P>Is there any way to achieve this result? Also, I am open to suggestions for other chart types displaying the information in a similar fashion (something that gives you the information at a glance). Thank you! </P><P></P><P><SPAN style="text-decoration: underline;">2017</SPAN></P><P><IMG alt="A.PNG" class="jive-image image-1" height="264" src="https://community.qlik.com/legacyfs/online/217028_A.PNG" style="width: 501px; height: 264.23px;" width="501" /></P><P></P><P><SPAN style="text-decoration: underline;">2018</SPAN></P><P><IMG alt="b.PNG" class="jive-image image-2" height="284" src="https://community.qlik.com/legacyfs/online/217029_b.PNG" style="width: 520.94px; height: 284px;" width="521" /></P><P></P><P><SPAN style="text-decoration: underline;">Outcome desired</SPAN></P><P><IMG alt="AB.png" class="jive-image image-3" height="294" src="https://community.qlik.com/legacyfs/online/217030_AB.png" style="width: 539px; height: 293.84px;" width="539" /></P></BODY></HTML> Mon, 29 Oct 2018 21:34:45 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88532#M509615 Anonymous 2018-10-29T21:34:45Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88533#M509616 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/15823">swuehl</A>‌ <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ <A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>‌ <A href="https://community.qlik.com/qlik-users/267799">jagangmohan</A>‌</P></BODY></HTML> Thu, 01 Nov 2018 21:02:27 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88533#M509616 Anonymous 2018-11-01T21:02:27Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88534#M509617 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe one solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_318316_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217333_QlikCommunity_Thread_318316_Pic1.JPG" style="height: 353px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 01 Nov 2018 22:37:56 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88534#M509617 MarcoWedel 2018-11-01T22:37:56Z Re: Scatter Chart https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88535#M509618 <HTML><HEAD></HEAD><BODY><P>Thank you Marco! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 07 Nov 2018 21:43:24 GMT https://community.qlik.com/t5/QlikView/Scatter-Chart/m-p/88535#M509618 Anonymous 2018-11-07T21:43:24Z