topic Re: How to transform a table? in QlikView

topic Re: How to transform a table? in QlikView https://community.qlik.com/t5/QlikView/How-to-transform-a-table/m-p/663060#M1061897 <HTML><HEAD></HEAD><BODY><P>Well I found out as I made few mistakes in both tebles.. this are new better tables..</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" height="20" width="64">Date</TD><TD class="xl65" width="64">quantity</TD><TD class="xl65" width="64">stock</TD><TD class="xl65" width="64">order</TD><TD class="xl65" width="64">value</TD></TR><TR><TD class="xl66" height="20">22012014</TD><TD class="xl67">15</TD><TD class="xl67">15</TD><TD class="xl68">90201</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl69" height="20">23012014</TD><TD align="right" class="xl70">-2</TD><TD class="xl69">13</TD><TD class="xl71">80450</TD></TR><TR><TD class="xl69" height="20">23012014</TD><TD align="right" class="xl70">-3</TD><TD class="xl69">10</TD><TD class="xl71">80451</TD></TR><TR><TD class="xl69" height="20">24012014</TD><TD align="right" class="xl70">-5</TD><TD class="xl69">5</TD><TD class="xl71">80452</TD></TR><TR><TD class="xl66" height="20">25012014</TD><TD class="xl67">10</TD><TD class="xl67">15</TD><TD class="xl68">90202</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl69" height="20">26012014</TD><TD align="right" class="xl70">-1</TD><TD class="xl69">14</TD><TD class="xl71">80453</TD></TR><TR><TD class="xl69" height="20">27012014</TD><TD align="right" class="xl70">-3</TD><TD class="xl69">11</TD><TD class="xl71">80454</TD></TR><TR><TD class="xl69" height="20">28012014</TD><TD align="right" class="xl70">-5</TD><TD class="xl69">6</TD><TD class="xl71">80455</TD></TR><TR><TD class="xl69" height="20">29012014</TD><TD align="right" class="xl70">-1</TD><TD class="xl69">5</TD><TD class="xl71">80456</TD></TR><TR><TD class="xl69" height="20">30012014</TD><TD align="right" class="xl70">-1</TD><TD class="xl69">4</TD><TD class="xl71">80457</TD></TR><TR><TD class="xl66" height="20">10022014</TD><TD class="xl67">5</TD><TD class="xl67">9</TD><TD class="xl68">90203</TD><TD class="xl66">13,7</TD></TR><TR><TD class="xl69" height="20">30022014</TD><TD align="right" class="xl70">-9</TD><TD class="xl69">0</TD><TD class="xl71">80458</TD></TR></TBODY></TABLE><P></P><P></P><P>And second table::</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" height="20" width="64">Date</TD><TD class="xl65" width="64">order</TD><TD class="xl65" width="64">receive</TD><TD class="xl65" width="64">quantity</TD><TD class="xl65" width="64">value</TD></TR><TR><TD class="xl66" height="20">23012014</TD><TD class="xl67">80450</TD><TD align="right">90201</TD><TD align="right">2</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">23012014</TD><TD class="xl67">80451</TD><TD align="right">90201</TD><TD align="right">3</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">24012014</TD><TD class="xl67">80452</TD><TD align="right">90201</TD><TD align="right">5</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">26012014</TD><TD class="xl67">80453</TD><TD align="right">90201</TD><TD align="right">1</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">27012014</TD><TD class="xl67">80454</TD><TD align="right">90201</TD><TD align="right">3</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">28012014</TD><TD class="xl67">80455</TD><TD align="right">90201</TD><TD align="right">1</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">28012014</TD><TD class="xl67">80455</TD><TD align="right">90202</TD><TD align="right">4</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">29012014</TD><TD class="xl67">80456</TD><TD align="right">90202</TD><TD align="right">1</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">30012014</TD><TD class="xl67">80457</TD><TD align="right">90202</TD><TD align="right">1</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90203</TD><TD align="right">4</TD><TD class="xl66">13,7</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90203</TD><TD align="right">5</TD><TD class="xl66">13,7</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 22 Sep 2014 14:38:05 GMT 2014-09-22T14:38:05Z How to transform a table? https://community.qlik.com/t5/QlikView/How-to-transform-a-table/m-p/663059#M1061896 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have stock table with receives and delivery from warehouse.</P><P>I would want to transform this table into new table where I could get info about value of delivery goods.</P><P>So basically FIFO what first goes int o stock had to also leave first form warehouse.</P><P></P><P>So from table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl63" height="20" width="64">Date</TD><TD class="xl63" width="64">quantity</TD><TD class="xl63" width="64">stock</TD><TD class="xl63" width="64">order</TD><TD class="xl63" width="64">value</TD></TR><TR><TD class="xl64" height="20">22012014</TD><TD class="xl65">15</TD><TD class="xl65">15</TD><TD class="xl66">90201</TD><TD class="xl64">11,3</TD></TR><TR><TD class="xl67" height="20">23012014</TD><TD align="right" class="xl68">-2</TD><TD class="xl67">13</TD><TD class="xl69">80450</TD></TR><TR><TD class="xl67" height="20">23012014</TD><TD align="right" class="xl68">-3</TD><TD class="xl67">10</TD><TD class="xl69">80451</TD></TR><TR><TD class="xl67" height="20">24012014</TD><TD align="right" class="xl68">-5</TD><TD class="xl67">5</TD><TD class="xl69">80452</TD></TR><TR><TD class="xl64" height="20">25012014</TD><TD class="xl65">10</TD><TD class="xl65">15</TD><TD class="xl66">90202</TD><TD class="xl64">12,5</TD></TR><TR><TD class="xl67" height="20">26012014</TD><TD align="right" class="xl68">-1</TD><TD class="xl67">14</TD><TD class="xl69">80453</TD></TR><TR><TD class="xl67" height="20">27012014</TD><TD align="right" class="xl68">-3</TD><TD class="xl67">11</TD><TD class="xl69">80454</TD></TR><TR><TD class="xl67" height="20">28012014</TD><TD align="right" class="xl68">-5</TD><TD class="xl67">10</TD><TD class="xl69">80455</TD></TR><TR><TD class="xl67" height="20">29012014</TD><TD align="right" class="xl68">-1</TD><TD class="xl67">9</TD><TD class="xl69">80456</TD></TR><TR><TD class="xl67" height="20">30012014</TD><TD align="right" class="xl68">-1</TD><TD class="xl67">8</TD><TD class="xl69">80457</TD></TR><TR><TD class="xl64" height="20">10022014</TD><TD class="xl65">5</TD><TD class="xl65">13</TD><TD class="xl66">90203</TD><TD class="xl64">13,7</TD></TR><TR><TD class="xl67" height="20">30022014</TD><TD align="right" class="xl68">-9</TD><TD class="xl67">4</TD><TD class="xl69"><P>80458</P></TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to get this table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" height="20" width="64">Date</TD><TD class="xl65" width="64">order</TD><TD class="xl65" width="64">receive</TD><TD class="xl65" width="64">quantity</TD><TD class="xl65" width="64">value</TD></TR><TR><TD class="xl66" height="20">23012014</TD><TD class="xl67">80450</TD><TD align="right">90201</TD><TD align="right">2</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">23012014</TD><TD class="xl67">80451</TD><TD align="right">90201</TD><TD align="right">3</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">24012014</TD><TD class="xl67">80452</TD><TD align="right">90201</TD><TD align="right">5</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">26012014</TD><TD class="xl67">80453</TD><TD align="right">90201</TD><TD align="right">1</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">27012014</TD><TD class="xl67">80454</TD><TD align="right">90201</TD><TD align="right">3</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">28012014</TD><TD class="xl67">80455</TD><TD align="right">90201</TD><TD align="right">1</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">28012014</TD><TD class="xl67">80455</TD><TD align="right">90202</TD><TD align="right">4</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">29012014</TD><TD class="xl67">80456</TD><TD align="right">90202</TD><TD align="right">1</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">30012014</TD><TD class="xl67">80457</TD><TD align="right">90202</TD><TD align="right">1</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90202</TD><TD align="right">8</TD><TD class="xl66">13,7</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90203</TD><TD align="right">8</TD><TD class="xl66">13,7</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90203</TD><TD align="right">8</TD><TD class="xl66">13,7</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 22 Sep 2014 14:28:10 GMT https://community.qlik.com/t5/QlikView/How-to-transform-a-table/m-p/663059#M1061896 2014-09-22T14:28:10Z Re: How to transform a table? https://community.qlik.com/t5/QlikView/How-to-transform-a-table/m-p/663060#M1061897 <HTML><HEAD></HEAD><BODY><P>Well I found out as I made few mistakes in both tebles.. this are new better tables..</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" height="20" width="64">Date</TD><TD class="xl65" width="64">quantity</TD><TD class="xl65" width="64">stock</TD><TD class="xl65" width="64">order</TD><TD class="xl65" width="64">value</TD></TR><TR><TD class="xl66" height="20">22012014</TD><TD class="xl67">15</TD><TD class="xl67">15</TD><TD class="xl68">90201</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl69" height="20">23012014</TD><TD align="right" class="xl70">-2</TD><TD class="xl69">13</TD><TD class="xl71">80450</TD></TR><TR><TD class="xl69" height="20">23012014</TD><TD align="right" class="xl70">-3</TD><TD class="xl69">10</TD><TD class="xl71">80451</TD></TR><TR><TD class="xl69" height="20">24012014</TD><TD align="right" class="xl70">-5</TD><TD class="xl69">5</TD><TD class="xl71">80452</TD></TR><TR><TD class="xl66" height="20">25012014</TD><TD class="xl67">10</TD><TD class="xl67">15</TD><TD class="xl68">90202</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl69" height="20">26012014</TD><TD align="right" class="xl70">-1</TD><TD class="xl69">14</TD><TD class="xl71">80453</TD></TR><TR><TD class="xl69" height="20">27012014</TD><TD align="right" class="xl70">-3</TD><TD class="xl69">11</TD><TD class="xl71">80454</TD></TR><TR><TD class="xl69" height="20">28012014</TD><TD align="right" class="xl70">-5</TD><TD class="xl69">6</TD><TD class="xl71">80455</TD></TR><TR><TD class="xl69" height="20">29012014</TD><TD align="right" class="xl70">-1</TD><TD class="xl69">5</TD><TD class="xl71">80456</TD></TR><TR><TD class="xl69" height="20">30012014</TD><TD align="right" class="xl70">-1</TD><TD class="xl69">4</TD><TD class="xl71">80457</TD></TR><TR><TD class="xl66" height="20">10022014</TD><TD class="xl67">5</TD><TD class="xl67">9</TD><TD class="xl68">90203</TD><TD class="xl66">13,7</TD></TR><TR><TD class="xl69" height="20">30022014</TD><TD align="right" class="xl70">-9</TD><TD class="xl69">0</TD><TD class="xl71">80458</TD></TR></TBODY></TABLE><P></P><P></P><P>And second table::</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" height="20" width="64">Date</TD><TD class="xl65" width="64">order</TD><TD class="xl65" width="64">receive</TD><TD class="xl65" width="64">quantity</TD><TD class="xl65" width="64">value</TD></TR><TR><TD class="xl66" height="20">23012014</TD><TD class="xl67">80450</TD><TD align="right">90201</TD><TD align="right">2</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">23012014</TD><TD class="xl67">80451</TD><TD align="right">90201</TD><TD align="right">3</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">24012014</TD><TD class="xl67">80452</TD><TD align="right">90201</TD><TD align="right">5</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">26012014</TD><TD class="xl67">80453</TD><TD align="right">90201</TD><TD align="right">1</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">27012014</TD><TD class="xl67">80454</TD><TD align="right">90201</TD><TD align="right">3</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">28012014</TD><TD class="xl67">80455</TD><TD align="right">90201</TD><TD align="right">1</TD><TD class="xl66">11,3</TD></TR><TR><TD class="xl66" height="20">28012014</TD><TD class="xl67">80455</TD><TD align="right">90202</TD><TD align="right">4</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">29012014</TD><TD class="xl67">80456</TD><TD align="right">90202</TD><TD align="right">1</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">30012014</TD><TD class="xl67">80457</TD><TD align="right">90202</TD><TD align="right">1</TD><TD class="xl66">12,5</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90203</TD><TD align="right">4</TD><TD class="xl66">13,7</TD></TR><TR><TD class="xl66" height="20">30022014</TD><TD class="xl67">80458</TD><TD align="right">90203</TD><TD align="right">5</TD><TD class="xl66">13,7</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 22 Sep 2014 14:38:05 GMT https://community.qlik.com/t5/QlikView/How-to-transform-a-table/m-p/663060#M1061897 2014-09-22T14:38:05Z