topic Recommended Purchases in QlikView

topic Recommended Purchases in QlikView https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568029#M1111639 <HTML><HEAD></HEAD><BODY><P>Trying to work out how to show what percentage of my recommended spares list my dealers are purchasing?</P><P></P><P>Example Rec List :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="502"><TBODY><TR><TD colspan="2" height="20" width="151">Reccomended Spares</TD></TR><TR><TD height="20">Family</TD><TD>Part No</TD><TD>Desc</TD><TD>Type</TD><TD class="xl65">Car Qty</TD><TD class="xl65">Rec Qty</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB1</TD><TD>A Part Desc</TD><TD>Engine</TD><TD class="xl65">5</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Red Car</TD><TD>AB2</TD><TD>A Part Desc</TD><TD>Wheels</TD><TD class="xl65">7</TD><TD class="xl65">3</TD></TR><TR><TD height="20">Green Car</TD><TD>AB3</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Red Car</TD><TD>AB4</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">10</TD><TD class="xl65">5</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB5</TD><TD>A Part Desc</TD><TD>Engine</TD><TD class="xl65">22</TD><TD class="xl65">15</TD></TR><TR><TD height="20">Red Car</TD><TD>AB6</TD><TD>A Part Desc</TD><TD>Wheels</TD><TD class="xl65">5</TD><TD class="xl65">4</TD></TR><TR><TD height="20">Green Car</TD><TD>AB7</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Red Car</TD><TD>AB8</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">2</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Green Car</TD><TD>AB9</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Red Car</TD><TD>AB10</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">10</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB11</TD><TD>A Part Desc</TD><TD>Engine</TD><TD class="xl65">40</TD><TD class="xl65">10</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB12</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">30</TD><TD class="xl65">20</TD></TR><TR><TD height="20">Red Car</TD><TD>AB13</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">5</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Green Car</TD><TD>AB14</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">7</TD><TD class="xl65">4</TD></TR></TBODY></TABLE><P></P><P></P><P>Example Sales List</P><TABLE border="0" cellpadding="0" cellspacing="0" width="462"><TBODY><TR><TD height="20" width="131">Dealer</TD><TD width="75">Date</TD><TD width="64">Month</TD><TD class="xl65" width="64">Year</TD><TD width="64">Item</TD><TD class="xl65" width="64">Qty</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">22/11/2013</TD><TD class="xl67">Nov</TD><TD class="xl65">2013</TD><TD>AB4</TD><TD class="xl65">1</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">05/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">28/01/2013</TD><TD class="xl67">Jan</TD><TD class="xl65">2013</TD><TD>AB11</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">25/01/2013</TD><TD class="xl67">Jan</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">08/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB1</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">22/12/2013</TD><TD class="xl67">Dec</TD><TD class="xl65">2013</TD><TD>AB9</TD><TD class="xl65">1</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">20/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB7</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">18/12/2013</TD><TD class="xl67">Dec</TD><TD class="xl65">2013</TD><TD>AB2</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">18/06/2013</TD><TD class="xl67">Jun</TD><TD class="xl65">2013</TD><TD>AB14</TD><TD class="xl65">10</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">01/02/2013</TD><TD class="xl67">Feb</TD><TD class="xl65">2013</TD><TD>AB3</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">01/03/2013</TD><TD class="xl67">Mar</TD><TD class="xl65">2013</TD><TD>AB10</TD><TD class="xl65">9</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">04/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">09/05/2013</TD><TD class="xl67">May</TD><TD class="xl65">2013</TD><TD>AB4</TD><TD class="xl65">5</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">07/09/2013</TD><TD class="xl67">Sep</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">25/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB11</TD><TD class="xl65">15</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">09/04/2013</TD><TD class="xl67">Apr</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">5</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">11/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">6</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">16/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">27/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB9</TD><TD class="xl65">1</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">07/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB7</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">15/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB2</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">13/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB14</TD><TD class="xl65">12</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">20/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB3</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">28/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB10</TD><TD class="xl65">6</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">23/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB3</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">24/03/2013</TD><TD class="xl67">Mar</TD><TD class="xl65">2013</TD><TD>AB10</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">21/09/2013</TD><TD class="xl67">Sep</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">5</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">29/09/2013</TD><TD class="xl67">Sep</TD><TD class="xl65">2013</TD><TD>AB4</TD><TD class="xl65">3</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">26/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">5</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">24/05/2013</TD><TD class="xl67">May</TD><TD class="xl65">2013</TD><TD>AB11</TD><TD class="xl65">60</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">03/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">1</TD></TR></TBODY></TABLE><P></P><P></P><P>Required Output :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="342"><TBODY><TR><TD height="20" width="64">Dealer</TD><TD width="64">Part No</TD><TD width="86">Bought Qty</TD><TD width="64">Rec Qty</TD><TD width="64">% Purchased</TD></TR><TR><TD height="20">Autoland</TD><TD>AB1</TD><TD align="right">1</TD><TD align="right">2</TD><TD align="right" class="xl65">50%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB11</TD><TD align="right">1</TD><TD align="right">10</TD><TD align="right" class="xl65">10%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB13</TD><TD align="right">7</TD><TD align="right">2</TD><TD align="right" class="xl65">350%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB14</TD><TD align="right">10</TD><TD align="right">4</TD><TD align="right" class="xl65">250%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB2</TD><TD align="right">4</TD><TD align="right">3</TD><TD align="right" class="xl65">133%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB3</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB8</TD><TD align="right">6</TD><TD align="right">1</TD><TD align="right" class="xl65">600%</TD></TR><TR><TD height="20">Donands</TD><TD>AB1</TD><TD align="right">2</TD><TD align="right">2</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">Donands</TD><TD>AB10</TD><TD align="right">16</TD><TD align="right">2</TD><TD align="right" class="xl65">800%</TD></TR><TR><TD height="20">Donands</TD><TD>AB8</TD><TD align="right">1</TD><TD align="right">1</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB11</TD><TD align="right">60</TD><TD align="right">10</TD><TD align="right" class="xl65">600%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB13</TD><TD align="right">5</TD><TD align="right">2</TD><TD align="right" class="xl65">250%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB4</TD><TD align="right">3</TD><TD align="right">5</TD><TD align="right" class="xl65">60%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB7</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB8</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB13</TD><TD align="right">2</TD><TD align="right">2</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB14</TD><TD align="right">12</TD><TD align="right">4</TD><TD align="right" class="xl65">300%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB3</TD><TD align="right">3</TD><TD align="right">1</TD><TD align="right" class="xl65">300%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB4</TD><TD align="right">5</TD><TD align="right">5</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB11</TD><TD align="right">15</TD><TD align="right">10</TD><TD align="right" class="xl65">150%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB4</TD><TD align="right">1</TD><TD align="right">5</TD><TD align="right" class="xl65">20%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB8</TD><TD align="right">5</TD><TD align="right">1</TD><TD align="right" class="xl65">500%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB9</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR></TBODY></TABLE><P></P><P></P><P>Any direction on this?</P></BODY></HTML> Tue, 25 Feb 2014 16:56:47 GMT dmac1971 2014-02-25T16:56:47Z Recommended Purchases https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568029#M1111639 <HTML><HEAD></HEAD><BODY><P>Trying to work out how to show what percentage of my recommended spares list my dealers are purchasing?</P><P></P><P>Example Rec List :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="502"><TBODY><TR><TD colspan="2" height="20" width="151">Reccomended Spares</TD></TR><TR><TD height="20">Family</TD><TD>Part No</TD><TD>Desc</TD><TD>Type</TD><TD class="xl65">Car Qty</TD><TD class="xl65">Rec Qty</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB1</TD><TD>A Part Desc</TD><TD>Engine</TD><TD class="xl65">5</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Red Car</TD><TD>AB2</TD><TD>A Part Desc</TD><TD>Wheels</TD><TD class="xl65">7</TD><TD class="xl65">3</TD></TR><TR><TD height="20">Green Car</TD><TD>AB3</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Red Car</TD><TD>AB4</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">10</TD><TD class="xl65">5</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB5</TD><TD>A Part Desc</TD><TD>Engine</TD><TD class="xl65">22</TD><TD class="xl65">15</TD></TR><TR><TD height="20">Red Car</TD><TD>AB6</TD><TD>A Part Desc</TD><TD>Wheels</TD><TD class="xl65">5</TD><TD class="xl65">4</TD></TR><TR><TD height="20">Green Car</TD><TD>AB7</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Red Car</TD><TD>AB8</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">2</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Green Car</TD><TD>AB9</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Red Car</TD><TD>AB10</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">10</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB11</TD><TD>A Part Desc</TD><TD>Engine</TD><TD class="xl65">40</TD><TD class="xl65">10</TD></TR><TR><TD height="20">Blue Car</TD><TD>AB12</TD><TD>A Part Desc</TD><TD>Bodywork</TD><TD class="xl65">30</TD><TD class="xl65">20</TD></TR><TR><TD height="20">Red Car</TD><TD>AB13</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">5</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Green Car</TD><TD>AB14</TD><TD>A Part Desc</TD><TD>Electrical</TD><TD class="xl65">7</TD><TD class="xl65">4</TD></TR></TBODY></TABLE><P></P><P></P><P>Example Sales List</P><TABLE border="0" cellpadding="0" cellspacing="0" width="462"><TBODY><TR><TD height="20" width="131">Dealer</TD><TD width="75">Date</TD><TD width="64">Month</TD><TD class="xl65" width="64">Year</TD><TD width="64">Item</TD><TD class="xl65" width="64">Qty</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">22/11/2013</TD><TD class="xl67">Nov</TD><TD class="xl65">2013</TD><TD>AB4</TD><TD class="xl65">1</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">05/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">28/01/2013</TD><TD class="xl67">Jan</TD><TD class="xl65">2013</TD><TD>AB11</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">25/01/2013</TD><TD class="xl67">Jan</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">08/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB1</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">22/12/2013</TD><TD class="xl67">Dec</TD><TD class="xl65">2013</TD><TD>AB9</TD><TD class="xl65">1</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">20/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB7</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">18/12/2013</TD><TD class="xl67">Dec</TD><TD class="xl65">2013</TD><TD>AB2</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">18/06/2013</TD><TD class="xl67">Jun</TD><TD class="xl65">2013</TD><TD>AB14</TD><TD class="xl65">10</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">01/02/2013</TD><TD class="xl67">Feb</TD><TD class="xl65">2013</TD><TD>AB3</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">01/03/2013</TD><TD class="xl67">Mar</TD><TD class="xl65">2013</TD><TD>AB10</TD><TD class="xl65">9</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">04/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">09/05/2013</TD><TD class="xl67">May</TD><TD class="xl65">2013</TD><TD>AB4</TD><TD class="xl65">5</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">07/09/2013</TD><TD class="xl67">Sep</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">25/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB11</TD><TD class="xl65">15</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">09/04/2013</TD><TD class="xl67">Apr</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">5</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">11/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">6</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">16/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB1</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">27/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB9</TD><TD class="xl65">1</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">07/07/2013</TD><TD class="xl67">Jul</TD><TD class="xl65">2013</TD><TD>AB7</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">15/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB2</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">13/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB14</TD><TD class="xl65">12</TD></TR><TR><TD height="20">Just Drive</TD><TD align="right" class="xl66">20/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB3</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">28/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB10</TD><TD class="xl65">6</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">23/08/2013</TD><TD class="xl67">Aug</TD><TD class="xl65">2013</TD><TD>AB3</TD><TD class="xl65">2</TD></TR><TR><TD height="20">Donands</TD><TD align="right" class="xl66">24/03/2013</TD><TD class="xl67">Mar</TD><TD class="xl65">2013</TD><TD>AB10</TD><TD class="xl65">1</TD></TR><TR><TD height="20">Qual Cars</TD><TD align="right" class="xl66">21/09/2013</TD><TD class="xl67">Sep</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">5</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">29/09/2013</TD><TD class="xl67">Sep</TD><TD class="xl65">2013</TD><TD>AB4</TD><TD class="xl65">3</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">26/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB8</TD><TD class="xl65">5</TD></TR><TR><TD height="20">GG Cars</TD><TD align="right" class="xl66">24/05/2013</TD><TD class="xl67">May</TD><TD class="xl65">2013</TD><TD>AB11</TD><TD class="xl65">60</TD></TR><TR><TD height="20">Autoland</TD><TD align="right" class="xl66">03/10/2013</TD><TD class="xl67">Oct</TD><TD class="xl65">2013</TD><TD>AB13</TD><TD class="xl65">1</TD></TR></TBODY></TABLE><P></P><P></P><P>Required Output :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="342"><TBODY><TR><TD height="20" width="64">Dealer</TD><TD width="64">Part No</TD><TD width="86">Bought Qty</TD><TD width="64">Rec Qty</TD><TD width="64">% Purchased</TD></TR><TR><TD height="20">Autoland</TD><TD>AB1</TD><TD align="right">1</TD><TD align="right">2</TD><TD align="right" class="xl65">50%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB11</TD><TD align="right">1</TD><TD align="right">10</TD><TD align="right" class="xl65">10%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB13</TD><TD align="right">7</TD><TD align="right">2</TD><TD align="right" class="xl65">350%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB14</TD><TD align="right">10</TD><TD align="right">4</TD><TD align="right" class="xl65">250%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB2</TD><TD align="right">4</TD><TD align="right">3</TD><TD align="right" class="xl65">133%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB3</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR><TR><TD height="20">Autoland</TD><TD>AB8</TD><TD align="right">6</TD><TD align="right">1</TD><TD align="right" class="xl65">600%</TD></TR><TR><TD height="20">Donands</TD><TD>AB1</TD><TD align="right">2</TD><TD align="right">2</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">Donands</TD><TD>AB10</TD><TD align="right">16</TD><TD align="right">2</TD><TD align="right" class="xl65">800%</TD></TR><TR><TD height="20">Donands</TD><TD>AB8</TD><TD align="right">1</TD><TD align="right">1</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB11</TD><TD align="right">60</TD><TD align="right">10</TD><TD align="right" class="xl65">600%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB13</TD><TD align="right">5</TD><TD align="right">2</TD><TD align="right" class="xl65">250%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB4</TD><TD align="right">3</TD><TD align="right">5</TD><TD align="right" class="xl65">60%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB7</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR><TR><TD height="20">GG Cars</TD><TD>AB8</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB13</TD><TD align="right">2</TD><TD align="right">2</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB14</TD><TD align="right">12</TD><TD align="right">4</TD><TD align="right" class="xl65">300%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB3</TD><TD align="right">3</TD><TD align="right">1</TD><TD align="right" class="xl65">300%</TD></TR><TR><TD height="20">Just Drive</TD><TD>AB4</TD><TD align="right">5</TD><TD align="right">5</TD><TD align="right" class="xl65">100%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB11</TD><TD align="right">15</TD><TD align="right">10</TD><TD align="right" class="xl65">150%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB4</TD><TD align="right">1</TD><TD align="right">5</TD><TD align="right" class="xl65">20%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB8</TD><TD align="right">5</TD><TD align="right">1</TD><TD align="right" class="xl65">500%</TD></TR><TR><TD height="20">Qual Cars</TD><TD>AB9</TD><TD align="right">2</TD><TD align="right">1</TD><TD align="right" class="xl65">200%</TD></TR></TBODY></TABLE><P></P><P></P><P>Any direction on this?</P></BODY></HTML> Tue, 25 Feb 2014 16:56:47 GMT https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568029#M1111639 dmac1971 2014-02-25T16:56:47Z Re: Recommended Purchases https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568030#M1111640 <HTML><HEAD></HEAD><BODY><P>Like This?</P></BODY></HTML> Tue, 25 Feb 2014 17:15:20 GMT https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568030#M1111640 MK_QSL 2014-02-25T17:15:20Z Re: Recommended Purchases https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568031#M1111641 <HTML><HEAD></HEAD><BODY><P>It seems to me that if you rename [Part No] to Item you can use your two tables as they are and get the required output in a straigth table chart:</P><P></P><P><STRONG>SCRIPT</STRONG></P><P>[Example Rec List]:</P><P>LOAD Family, </P><P>     [Part No] as Item, </P><P>     Desc, </P><P>     Type, </P><P>     [Car Qty], </P><P>     [Rec Qty]</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2003" data-containertype="14" data-objectid="108643" data-objecttype="1" href="http://community.qlik.com/thread/108643">http://community.qlik.com/thread/108643</A><SPAN>]</SPAN></P><P>(html, codepage is 1252, embedded labels, table is @1, filters(</P><P>Remove(Row, Pos(Top, 1))</P><P>));</P><P></P><P>[Example Sales List]:</P><P>LOAD Dealer, </P><P>     Date, </P><P>     Month, </P><P>     Year, </P><P>     Item, </P><P>     Qty</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2003" data-containertype="14" data-objectid="108643" data-objecttype="1" href="http://community.qlik.com/thread/108643">http://community.qlik.com/thread/108643</A><SPAN>]</SPAN></P><P>(html, codepage is 1252, embedded labels, table is @2);</P><P></P><P><STRONG>RESULT</STRONG></P><P>expression are the last 3 cols</P><P>Sum ([Qty])</P><P>Sum ([Rec Qty])</P><P>column(1)/column(2)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="367"><TBODY><TR><TD class="xl63" height="17" width="98">Dealer</TD><TD class="xl63" style="border-left: none;" width="65">Part No</TD><TD class="xl63" style="border-left: none;" width="65">Bought Qty</TD><TD class="xl63" style="border-left: none;" width="68">Rec Qty</TD><TD class="xl63" style="border-left: none;" width="71">% Purchased</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB1</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB2</TD><TD class="xl64" style="border-top: none; border-left: none;">4</TD><TD class="xl64" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">133%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB3</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">200%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB8</TD><TD class="xl64" style="border-top: none; border-left: none;">6</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">600%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB11</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB13</TD><TD class="xl64" style="border-top: none; border-left: none;">7</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">350%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Autoland</TD><TD class="xl64" style="border-top: none; border-left: none;">AB14</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">250%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Donands</TD><TD class="xl64" style="border-top: none; border-left: none;">AB1</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Donands</TD><TD class="xl64" style="border-top: none; border-left: none;">AB8</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Donands</TD><TD class="xl64" style="border-top: none; border-left: none;">AB10</TD><TD class="xl64" style="border-top: none; border-left: none;">16</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">800%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">GG Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB4</TD><TD class="xl64" style="border-top: none; border-left: none;">3</TD><TD class="xl64" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">60%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">GG Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB7</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">200%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">GG Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB8</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">200%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">GG Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB11</TD><TD class="xl64" style="border-top: none; border-left: none;">60</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">600%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">GG Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB13</TD><TD class="xl64" style="border-top: none; border-left: none;">5</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">250%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Just Drive</TD><TD class="xl64" style="border-top: none; border-left: none;">AB3</TD><TD class="xl64" style="border-top: none; border-left: none;">3</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Just Drive</TD><TD class="xl64" style="border-top: none; border-left: none;">AB4</TD><TD class="xl64" style="border-top: none; border-left: none;">5</TD><TD class="xl64" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Just Drive</TD><TD class="xl64" style="border-top: none; border-left: none;">AB13</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Just Drive</TD><TD class="xl64" style="border-top: none; border-left: none;">AB14</TD><TD class="xl64" style="border-top: none; border-left: none;">12</TD><TD class="xl64" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Qual Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB4</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD class="xl64" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Qual Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB8</TD><TD class="xl64" style="border-top: none; border-left: none;">5</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">500%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Qual Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB9</TD><TD class="xl64" style="border-top: none; border-left: none;">2</TD><TD class="xl64" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">200%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Qual Cars</TD><TD class="xl64" style="border-top: none; border-left: none;">AB11</TD><TD class="xl64" style="border-top: none; border-left: none;">15</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">150%</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 25 Feb 2014 19:41:48 GMT https://community.qlik.com/t5/QlikView/Recommended-Purchases/m-p/568031#M1111641 maxgro 2014-02-25T19:41:48Z