topic How to create table Material Movement in QlikView

topic How to create table Material Movement in QlikView https://community.qlik.com/t5/QlikView/How-to-create-table-Material-Movement/m-p/932880#M963814 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Dear All master qlik,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Yesterday i've been asking and already got answered. But my boss said that the table should be more complicated than i asked yesterday.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">So this is the table of raw data :</SPAN></P><P>         </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"calibri,verdana,arial,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 500px; border-width: 1px; border-style: solid; border-color: #000000;"><TBODY><TR><TD class="xl63" height="20" style="font-family: calibri,verdana,arial,sans-serif;" width="25">PT</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="38">Estate</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="65">Date</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="55">Material</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="79">Material_Desc</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="104">Material_Grp_Desc</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="100">Total_Receipt_Qty</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="110">Total_Receipt_Value</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="87">Total_Issue_Qty</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="98">Total_Issue_Value</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">294,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">2.099.930,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-147,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-1.060.789,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">11,64</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">82.935.000,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-5,82</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-41.467.500,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-1,77</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-12.615.932,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">24,35</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">173.546.195,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-12,17</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-86.890.874,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">2,86</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">20.368.230,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-9,63</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-68.597.080,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-210,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-1.494.917,00</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">and from the table row data like above, i must create this kind of table :</SPAN></P><P>           </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"calibri, verdana, arial, sans-serif","verticalAlign":"middle"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2","verticalAlign":"middle","fontFamily":"calibri, verdana, arial, sans-serif"}" style="width: 750px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl65" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="19">PT</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="38">Estate</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="65">Date</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="55">Material</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="79">Material_Desc</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="104">Material_Grp_Desc</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="104">Start_Qty</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="104">Start_Value</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="100">Total_Receipt_Qty</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="110">Total_Receipt_Value</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="87">Total_Issue_Qty</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="98">Total_Issue_Value</TD><TD class="xl67" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="64">End_Qty</TD><TD class="xl67" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="95">End_Value</TD></TR><TR><TD class="xl68" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl69" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">294,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">2.099.930,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-147,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-1.060.789,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">147,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">1.039.141,00</TD></TR><TR><TD class="xl68" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl69" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">147,00</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">1.039.141,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">11,64</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">82.935.000,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-5,82</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-41.467.500,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">152,82</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">42.506.641,00</TD></TR><TR><TD class="xl68" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl69" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">152,82</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">42.506.641,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-1,77</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-12.615.932,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">151,05</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">29.890.709,00</TD></TR><TR><TD class="xl72" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl73" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">24,35</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">173.546.195,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-12,17</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-86.890.874,00</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">12,17</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">86.655.321,00</TD></TR><TR><TD class="xl72" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl73" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">12,17</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">86.655.321,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">2,86</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">20.368.230,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-9,63</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-68.597.080,00</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">5,40</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">38.426.471,00</TD></TR><TR><TD class="xl72" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl73" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">5,40</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">38.426.471,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-210,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-1.494.917,00</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-204,60</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">36.931.554,00</TD></TR></TBODY></TABLE><P></P><P>Please help me to create this above tabel, i need to add start_qty,start_value, end_qty, and end_value to the raw table.</P><P>So many thanks for the answer.</P><P></P><P>Regard's,</P><P>Hadi</P></BODY></HTML> Thu, 08 Oct 2015 02:36:30 GMT 2015-10-08T02:36:30Z How to create table Material Movement https://community.qlik.com/t5/QlikView/How-to-create-table-Material-Movement/m-p/932880#M963814 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Dear All master qlik,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Yesterday i've been asking and already got answered. But my boss said that the table should be more complicated than i asked yesterday.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">So this is the table of raw data :</SPAN></P><P>         </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"calibri,verdana,arial,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 500px; border-width: 1px; border-style: solid; border-color: #000000;"><TBODY><TR><TD class="xl63" height="20" style="font-family: calibri,verdana,arial,sans-serif;" width="25">PT</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="38">Estate</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="65">Date</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="55">Material</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="79">Material_Desc</TD><TD class="xl63" style="font-family: calibri,verdana,arial,sans-serif;" width="104">Material_Grp_Desc</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="100">Total_Receipt_Qty</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="110">Total_Receipt_Value</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="87">Total_Issue_Qty</TD><TD class="xl66" style="font-family: calibri,verdana,arial,sans-serif;" width="98">Total_Issue_Value</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">294,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">2.099.930,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-147,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-1.060.789,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">11,64</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">82.935.000,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-5,82</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-41.467.500,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-1,77</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-12.615.932,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">24,35</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">173.546.195,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-12,17</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-86.890.874,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">2,86</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">20.368.230,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-9,63</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-68.597.080,00</TD></TR><TR><TD class="xl64" height="20" style="font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl65" style="font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl64" style="font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-210,00</TD><TD class="xl67" style="font-family: calibri,verdana,arial,sans-serif;">-1.494.917,00</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">and from the table row data like above, i must create this kind of table :</SPAN></P><P>           </P><TABLE border="1px" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"calibri, verdana, arial, sans-serif","verticalAlign":"middle"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2","verticalAlign":"middle","fontFamily":"calibri, verdana, arial, sans-serif"}" style="width: 750px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl65" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="19">PT</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="38">Estate</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="65">Date</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="55">Material</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="79">Material_Desc</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="104">Material_Grp_Desc</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="104">Start_Qty</TD><TD class="xl65" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="104">Start_Value</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="100">Total_Receipt_Qty</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="110">Total_Receipt_Value</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="87">Total_Issue_Qty</TD><TD class="xl66" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="98">Total_Issue_Value</TD><TD class="xl67" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="64">End_Qty</TD><TD class="xl67" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;" width="95">End_Value</TD></TR><TR><TD class="xl68" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl69" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">294,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">2.099.930,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-147,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-1.060.789,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">147,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">1.039.141,00</TD></TR><TR><TD class="xl68" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl69" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">147,00</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">1.039.141,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">11,64</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">82.935.000,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-5,82</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-41.467.500,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">152,82</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">42.506.641,00</TD></TR><TR><TD class="xl68" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A1</TD><TD class="xl69" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl68" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">152,82</TD><TD class="xl77" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">42.506.641,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-1,77</TD><TD class="xl70" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-12.615.932,00</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">151,05</TD><TD align="right" class="xl71" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">29.890.709,00</TD></TR><TR><TD class="xl72" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl73" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/08/2013</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">24,35</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">173.546.195,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-12,17</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-86.890.874,00</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">12,17</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">86.655.321,00</TD></TR><TR><TD class="xl72" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl73" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/09/2013</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">12,17</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">86.655.321,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">2,86</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">20.368.230,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-9,63</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-68.597.080,00</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">5,40</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">38.426.471,00</TD></TR><TR><TD class="xl72" height="20" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">A2</TD><TD class="xl73" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">01/10/2013</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">10000018</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">BORATE</TD><TD class="xl72" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">Fertililizer</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">5,40</TD><TD class="xl74" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">38.426.471,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">0,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-210,00</TD><TD class="xl75" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-1.494.917,00</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">-204,60</TD><TD align="right" class="xl76" style="text-align: left; vertical-align: middle; font-family: calibri,verdana,arial,sans-serif;">36.931.554,00</TD></TR></TBODY></TABLE><P></P><P>Please help me to create this above tabel, i need to add start_qty,start_value, end_qty, and end_value to the raw table.</P><P>So many thanks for the answer.</P><P></P><P>Regard's,</P><P>Hadi</P></BODY></HTML> Thu, 08 Oct 2015 02:36:30 GMT https://community.qlik.com/t5/QlikView/How-to-create-table-Material-Movement/m-p/932880#M963814 2015-10-08T02:36:30Z