topic Matrix array in QlikView https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712166#M256378 <HTML><HEAD></HEAD><BODY><P> I have a next table</P><P>Table Purchase orders</P><P>Product,Ordernr, Qty, ETA</P><P>A,12345,10,20140615</P><P>A,12390,25,20140819</P><P>A,12455,50,20140720</P><P>B,12359,15,20140930</P><P>C,12300,20,20140509</P><P>C,12345,50,20140615</P><P></P><P>There are three Orders&nbsp; for Product A</P><P>There is one Order for Product B</P><P>There are two orders for Product C</P><P>Must be displayed in a array which is sorted on ETA</P><P>The o</P><P></P><P>Table Stock</P><P>Product, AFS</P><P>A,55</P><P>B,0</P><P>C,15</P><P></P><P>Tabel Product</P><P>Product Description,Usage</P><P>A,ProductA,40</P><P>B,ProductB,5</P><P>C,ProductC,10</P><P></P><P>We want this to have in a following matrix</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>AFS</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO Array1 Qty</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO# Array1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO Array1 Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">POT</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PO Array2 QTY </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PO# Array2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PO Array2 Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">POT</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">`PO Array3 Qty</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO Array3 Date</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">ProductA</TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">20140615</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">12455</TD><TD style="padding: 2px;">20140720</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">20140819</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">ProductB</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">12359</TD><TD style="padding: 2px;">20140930</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">ProductC</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">12300</TD><TD style="padding: 2px;">20140509</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">20140615</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>Can some please help me how to solve this.</P></BODY></HTML> Thu, 19 Jun 2014 12:13:59 GMT 2014-06-19T12:13:59Z Matrix array https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712166#M256378 <HTML><HEAD></HEAD><BODY><P> I have a next table</P><P>Table Purchase orders</P><P>Product,Ordernr, Qty, ETA</P><P>A,12345,10,20140615</P><P>A,12390,25,20140819</P><P>A,12455,50,20140720</P><P>B,12359,15,20140930</P><P>C,12300,20,20140509</P><P>C,12345,50,20140615</P><P></P><P>There are three Orders&nbsp; for Product A</P><P>There is one Order for Product B</P><P>There are two orders for Product C</P><P>Must be displayed in a array which is sorted on ETA</P><P>The o</P><P></P><P>Table Stock</P><P>Product, AFS</P><P>A,55</P><P>B,0</P><P>C,15</P><P></P><P>Tabel Product</P><P>Product Description,Usage</P><P>A,ProductA,40</P><P>B,ProductB,5</P><P>C,ProductC,10</P><P></P><P>We want this to have in a following matrix</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>AFS</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO Array1 Qty</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO# Array1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO Array1 Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">POT</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PO Array2 QTY </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PO# Array2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PO Array2 Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">POT</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">`PO Array3 Qty</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PO Array3 Date</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">ProductA</TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">20140615</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">12455</TD><TD style="padding: 2px;">20140720</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">20140819</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">ProductB</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">12359</TD><TD style="padding: 2px;">20140930</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">ProductC</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">12300</TD><TD style="padding: 2px;">20140509</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">20140615</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>Can some please help me how to solve this.</P></BODY></HTML> Thu, 19 Jun 2014 12:13:59 GMT https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712166#M256378 2014-06-19T12:13:59Z Re: Matrix array https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712167#M256379 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Thu, 19 Jun 2014 13:23:53 GMT https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712167#M256379 Gysbert_Wassenaar 2014-06-19T13:23:53Z Re: Matrix array https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712168#M256380 <HTML><HEAD></HEAD><BODY><P>Hoi Gysbert,</P><P></P><P>Dit werkt !</P><P>Bedankt</P><P>Arthur</P></BODY></HTML> Thu, 19 Jun 2014 13:27:50 GMT https://community.qlik.com/t5/QlikView/Matrix-array/m-p/712168#M256380 2014-06-19T13:27:50Z