topic Re: Transformation of cumulutad quarters in seperated quarters in QlikView https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341208#M413166 <HTML><HEAD></HEAD><BODY><P>I think it's already solved: <A href="https://community.qlik.com/message/1292870">Differenz von Tabellen mit gleicher Struktur</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 22 Jun 2017 16:58:54 GMT marcus_sommer 2017-06-22T16:58:54Z Transformation of cumulutad quarters in seperated quarters https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341206#M413164 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am very new to QlikView and have a problem where I havn't found already existing solutions in the community..</P><P></P><P>I have 4 tables with exactly same structure:</P><P></P><P>The Material Number is unique like a primary key.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Material Number</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Costs total</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">costs labour</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">costs material</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">1500</TD><TD style="padding: 2px;">500</TD></TR></TBODY></TABLE><P></P><P>The first table one has information for <SPAN style="color: #575757; text-decoration: underline;">Q1</SPAN><SPAN style="text-decoration: underline;">,</SPAN></P><P>the 2nd table has information for <SPAN style="color: #575757; text-decoration: underline;">Q2 + Q1,</SPAN></P><P>the 3rd table has information for<SPAN style="color: #575757; text-decoration: underline;"> Q3 + Q2 + Q1,</SPAN></P><P>the 4th table has information for <SPAN style="text-decoration: underline;">Q4 + Q3 + Q2 + Q1</SPAN></P><P></P><P><STRONG>I need information for each quarter separately.</STRONG></P><P></P><P>For example for getting the information for Q3 I need to do Q3-Q2 based on each Material Number.</P><P>The count of Material Numbers is also getting higher from quarter to quarter. </P><P>The information of the quarter is only mentioned in the title of the excel file: Q1_Material.qvd, Q1_Q2_Material.qvd, etc. </P><P></P><P>How can I do this in the script for all the quarters of a year?</P><P></P><P>Thank you very much!</P><P></P><P>Kind regards,</P><P>Martin</P></BODY></HTML> Thu, 22 Jun 2017 09:28:34 GMT https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341206#M413164 2017-06-22T09:28:34Z Re: Transformation of cumulutad quarters in seperated quarters https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341207#M413165 <HTML><HEAD></HEAD><BODY><P>Do you have some sample data you can share to play around with?</P></BODY></HTML> Thu, 22 Jun 2017 16:40:26 GMT https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341207#M413165 sunny_talwar 2017-06-22T16:40:26Z Re: Transformation of cumulutad quarters in seperated quarters https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341208#M413166 <HTML><HEAD></HEAD><BODY><P>I think it's already solved: <A href="https://community.qlik.com/message/1292870">Differenz von Tabellen mit gleicher Struktur</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 22 Jun 2017 16:58:54 GMT https://community.qlik.com/t5/QlikView/Transformation-of-cumulutad-quarters-in-seperated-quarters/m-p/1341208#M413166 marcus_sommer 2017-06-22T16:58:54Z