topic Re: Chart question in QlikView https://community.qlik.com/t5/QlikView/Chart-question/m-p/844067#M1004620 <HTML><HEAD></HEAD><BODY><P>HI Henrik,</P><P></P><P>you would use a pivot chart:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87556_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>See the attached simple example</P><P></P><P>HTH Andy</P></BODY></HTML> Tue, 26 May 2015 15:10:22 GMT awhitfield 2015-05-26T15:10:22Z Chart question https://community.qlik.com/t5/QlikView/Chart-question/m-p/844065#M1004618 <HTML><HEAD></HEAD><BODY><P>I have a table that contains an amount of sold items, in another table the unit for the sold items are located, they are connected with a field for salesman,</P><P>If I make a chart it will be displayed like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Salesman</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Unit</STRONG></TH></TR><TR><TD style="padding: 2px;">Mr A</TD>100<TD style="padding: 2px;"><P>Volvo</P></TD><TD style="padding: 2px;"><P></P></TD></TR><TR><TD style="padding: 2px;">Mr A</TD>100<TD style="padding: 2px;">BMW</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>Is there a way with set analysis to make it display as this?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Salesman</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount(Volvo)</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount(BMW)</STRONG></TH></TR><TR><TD style="padding: 2px;">Mr A</TD>100<TD style="padding: 2px;">100</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 25 May 2015 13:09:13 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/844065#M1004618 2015-05-25T13:09:13Z Re: Chart question https://community.qlik.com/t5/QlikView/Chart-question/m-p/844066#M1004619 <HTML><HEAD></HEAD><BODY><P>use a pivot table with dimension Salesman and Amount, and expression sum(Unit)</P></BODY></HTML> Tue, 26 May 2015 05:51:01 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/844066#M1004619 ecolomer 2015-05-26T05:51:01Z Re: Chart question https://community.qlik.com/t5/QlikView/Chart-question/m-p/844067#M1004620 <HTML><HEAD></HEAD><BODY><P>HI Henrik,</P><P></P><P>you would use a pivot chart:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87556_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>See the attached simple example</P><P></P><P>HTH Andy</P></BODY></HTML> Tue, 26 May 2015 15:10:22 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/844067#M1004620 awhitfield 2015-05-26T15:10:22Z