topic Re: how to create this chart in QlikView https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219778#M390213 <HTML><HEAD></HEAD><BODY><P>Hi Jean,</P><P></P><P>Did it work? </P></BODY></HTML> Thu, 08 Dec 2016 07:44:11 GMT Anonymous 2016-12-08T07:44:11Z how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219770#M390205 <HTML><HEAD></HEAD><BODY><P>I have two tables</P><P></P><P>First table:</P><P>customer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item</P><P>cust1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item1</P><P>cust1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item2</P><P>cust2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item1</P><P>cust2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item4</P><P></P><P>Second Table:</P><P>item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp; qty</P><P>item1&nbsp;&nbsp;&nbsp;&nbsp; cust1&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>item1&nbsp;&nbsp;&nbsp;&nbsp; cust3&nbsp;&nbsp;&nbsp;&nbsp; 14</P><P>item1&nbsp;&nbsp;&nbsp;&nbsp; cust2&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>item2&nbsp;&nbsp;&nbsp;&nbsp; cust5&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>item2&nbsp;&nbsp;&nbsp;&nbsp; cust1&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P></P><P>they are linked on item</P><P></P><P>now i need the following chart</P><P>customer&nbsp;&nbsp;&nbsp;&nbsp; item&nbsp;&nbsp;&nbsp;&nbsp; qty</P><P>cust1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item1&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>cust1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>cust2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item1&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>cust2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item4&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P></P><P>any suggestion on the expression for the qty?</P></BODY></HTML> Wed, 07 Dec 2016 09:09:09 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219770#M390205 jduluc12 2016-12-07T09:09:09Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219771#M390206 <HTML><HEAD></HEAD><BODY><P>Why do you need 1st table when you can alias name field as Customer in 2nd table?</P></BODY></HTML> Wed, 07 Dec 2016 09:11:48 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219771#M390206 shraddha_g 2016-12-07T09:11:48Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219772#M390207 <HTML><HEAD></HEAD><BODY><P>both are coming from different data source and and there are some more fields in the first table that i need to take on chart.</P><P>i removed them to simplify the problem.</P></BODY></HTML> Wed, 07 Dec 2016 09:18:46 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219772#M390207 jduluc12 2016-12-07T09:18:46Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219773#M390208 <HTML><HEAD></HEAD><BODY><P>In Simple table</P><P>DImension1 : Customer</P><P>Dimension 2: Item</P><P></P><P>Measure : sum(Qty)</P></BODY></HTML> Wed, 07 Dec 2016 09:29:37 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219773#M390208 shraddha_g 2016-12-07T09:29:37Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219774#M390209 <HTML><HEAD></HEAD><BODY><P>that does not work...</P><P>because</P><P>it brings data like this</P><P></P><P>Customer&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp; sum(qty)</P><P>cust1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12+14+15</P><P></P><P>and henceforth..</P></BODY></HTML> Wed, 07 Dec 2016 09:42:00 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219774#M390209 jduluc12 2016-12-07T09:42:00Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219775#M390210 <HTML><HEAD></HEAD><BODY><P>when linking 2 tables ,make composite key of Item and Customer</P></BODY></HTML> Wed, 07 Dec 2016 09:48:45 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219775#M390210 shraddha_g 2016-12-07T09:48:45Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219776#M390211 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This will happen since you have linked tables only on basis of '<STRONG>Item</STRONG>" field.</P><P>Is there any other key field to link the tables? Else you can link it on basis of Item &amp; Customer</P><P></P><P>First table:</P><P>Load customer,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; customer &amp; Item as Key</P><P>From....;</P><P></P><P>Second Table:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; qty,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; name &amp; Item as Key</P><P>From...;</P></BODY></HTML> Wed, 07 Dec 2016 09:54:39 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219776#M390211 Anonymous 2016-12-07T09:54:39Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219777#M390212 <HTML><HEAD></HEAD><BODY><P>This is what i am trying.</P></BODY></HTML> Wed, 07 Dec 2016 18:44:34 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219777#M390212 jduluc12 2016-12-07T18:44:34Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219778#M390213 <HTML><HEAD></HEAD><BODY><P>Hi Jean,</P><P></P><P>Did it work? </P></BODY></HTML> Thu, 08 Dec 2016 07:44:11 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219778#M390213 Anonymous 2016-12-08T07:44:11Z Re: how to create this chart https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219779#M390214 <HTML><HEAD></HEAD><BODY><P>Yes It did.</P><P>Thanks!</P></BODY></HTML> Thu, 08 Dec 2016 14:10:29 GMT https://community.qlik.com/t5/QlikView/how-to-create-this-chart/m-p/1219779#M390214 jduluc12 2016-12-08T14:10:29Z