topic Re: How to build a dotpot in QlikView https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481722#M480494 <HTML><HEAD></HEAD><BODY><P>Have you tried a scatter chart with dimension city and the two expressions</P><P>=sum(population)</P><P>=sum(jobs)</P></BODY></HTML> Sat, 23 Nov 2013 13:12:16 GMT swuehl 2013-11-23T13:12:16Z How to build a dotpot https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481721#M480493 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i'm new int the world of Qlik View and i have a question regarding to build a correct dotplot. </P><P>Now, this is my Excel sheet:</P><P></P><P>city&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; population&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jobs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>New York&nbsp;&nbsp;&nbsp;&nbsp; 8.300.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.500.000</P><P>London&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.800.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.600.000</P><P>Berlin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.400.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.100.000</P><P></P><P></P><P>The dimensions are "population" and "jobs" and now i want to see where the city´s are in the dotplot based on the two dimensions. So my problem is maybe to create a correct formula for the attribute "city"?! Can you help me how it works to create the formula in the Expression formula field?</P><P></P><P>Thanks,</P><P>Thomas </P></BODY></HTML> Sat, 23 Nov 2013 12:41:27 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481721#M480493 2013-11-23T12:41:27Z Re: How to build a dotpot https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481722#M480494 <HTML><HEAD></HEAD><BODY><P>Have you tried a scatter chart with dimension city and the two expressions</P><P>=sum(population)</P><P>=sum(jobs)</P></BODY></HTML> Sat, 23 Nov 2013 13:12:16 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481722#M480494 swuehl 2013-11-23T13:12:16Z Re: Re: How to build a dotpot https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481723#M480495 <HTML><HEAD></HEAD><BODY><P><STRONG>Thomas</STRONG></P><P></P><P>I agree with <SPAN style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><A _jive_internal="true" data-avatarid="-1" data-userid="15823" data-username="swuehl" href="https://community.qlik.com/people/swuehl" style="padding: 0 3px 0 0; font-weight: inherit; font-style: inherit; font-size: 1.1em; font-family: inherit; color: #3778c7;">swuehl, </A></STRONG></SPAN> attached is a simple example qvw.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sat, 23 Nov 2013 13:26:40 GMT https://community.qlik.com/t5/QlikView/How-to-build-a-dotpot/m-p/481723#M480495 Anonymous 2013-11-23T13:26:40Z