topic charts in QlikView https://community.qlik.com/t5/QlikView/charts/m-p/1009925#M951120 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have source table like this . when i am using bar chart i did'n get proper output.</P><P>please give any idea . my output file is attached in down</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1280px;"><TBODY><TR><TD class="xl67" height="20" width="124">Country</TD><TD class="xl66" width="186">MTD Planned Sale</TD><TD class="xl66" width="213">MTD Actual Sale</TD><TD class="xl66" width="161">QTD Planned Sale</TD><TD class="xl66" width="170">QTD Actual Sale</TD><TD class="xl66" width="175">YTD Planned Sale</TD><TD class="xl66" width="251">YTD&nbsp; Actual Sale</TD></TR><TR><TD class="xl65" height="20">USA</TD><TD align="right" class="xl65" style="border-left: none;">20000</TD><TD align="right" class="xl65" style="border-left: none;">15000</TD><TD align="right" class="xl65" style="border-left: none;">40000</TD><TD align="right" class="xl65" style="border-left: none;">38000</TD><TD align="right" class="xl65" style="border-left: none;">240000</TD><TD align="right" class="xl65" style="border-left: none;">220000</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">China</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">21000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">14000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">250000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">230000</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Germany</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">22000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">260000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">240000</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Japan</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">33000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">23000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">25000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">220000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">230000</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 30 Nov 2015 17:00:08 GMT maniram23 2015-11-30T17:00:08Z charts https://community.qlik.com/t5/QlikView/charts/m-p/1009925#M951120 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have source table like this . when i am using bar chart i did'n get proper output.</P><P>please give any idea . my output file is attached in down</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1280px;"><TBODY><TR><TD class="xl67" height="20" width="124">Country</TD><TD class="xl66" width="186">MTD Planned Sale</TD><TD class="xl66" width="213">MTD Actual Sale</TD><TD class="xl66" width="161">QTD Planned Sale</TD><TD class="xl66" width="170">QTD Actual Sale</TD><TD class="xl66" width="175">YTD Planned Sale</TD><TD class="xl66" width="251">YTD&nbsp; Actual Sale</TD></TR><TR><TD class="xl65" height="20">USA</TD><TD align="right" class="xl65" style="border-left: none;">20000</TD><TD align="right" class="xl65" style="border-left: none;">15000</TD><TD align="right" class="xl65" style="border-left: none;">40000</TD><TD align="right" class="xl65" style="border-left: none;">38000</TD><TD align="right" class="xl65" style="border-left: none;">240000</TD><TD align="right" class="xl65" style="border-left: none;">220000</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">China</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">21000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">14000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">250000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">230000</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Germany</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">22000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">260000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">240000</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Japan</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">33000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">23000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">25000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">220000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">230000</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 30 Nov 2015 17:00:08 GMT https://community.qlik.com/t5/QlikView/charts/m-p/1009925#M951120 maniram23 2015-11-30T17:00:08Z Re: charts https://community.qlik.com/t5/QlikView/charts/m-p/1009926#M951121 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You need to clarify the problem.</P><P></P><P>What output were you expecting?</P><P></P><P>Joe</P></BODY></HTML> Mon, 30 Nov 2015 20:19:51 GMT https://community.qlik.com/t5/QlikView/charts/m-p/1009926#M951121 mazacini 2015-11-30T20:19:51Z Re: charts https://community.qlik.com/t5/QlikView/charts/m-p/1009927#M951122 <HTML><HEAD></HEAD><BODY><P>Hi Mani,</P><P>A simple crosstable statement in your load script is all you need to achieve what you want, see attached qvw:</P><P></P><P><IMG alt="Charts.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107671_Charts.jpg" style="height: 333px; width: 620px;" /></P></BODY></HTML> Mon, 30 Nov 2015 21:21:58 GMT https://community.qlik.com/t5/QlikView/charts/m-p/1009927#M951122 effinty2112 2015-11-30T21:21:58Z