topic Build up a cross table in QlikView https://community.qlik.com/t5/QlikView/Build-up-a-cross-table/m-p/234868#M86195 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P>I've got a problem and can't get to the solution by myselfe.</P><P>I have 2 tables:</P><P>First table has got several periodes:</P><P>Periode</P><P>01-2010</P><P>02-2010</P><P>03-2010</P><P>04-2011</P><P>...</P><P>Second table is like:</P><P>Name; Start Periode; Cost per Periode</P><P>Power ; 01-2010; 210</P><P>Water; 03-2010; 150</P><P>...</P><P></P><P>Now I need to join both Tables. I want the result-table to look like:</P><P>Periode; Costs; Name</P><P>01-2010; 210; Power</P><P>02-2010; 210; Power</P><P>03-2010; 210; Power</P><P>03-2010; 150; Water</P><P>04-2010; 210; Power</P><P>04-2010; 150; Water</P><P>...</P><P>Has anyone got a hint for me?</P><P>Thanks a lot ... Stefan</P></BODY></HTML> Tue, 27 Jul 2010 14:47:23 GMT 2010-07-27T14:47:23Z Build up a cross table https://community.qlik.com/t5/QlikView/Build-up-a-cross-table/m-p/234868#M86195 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P>I've got a problem and can't get to the solution by myselfe.</P><P>I have 2 tables:</P><P>First table has got several periodes:</P><P>Periode</P><P>01-2010</P><P>02-2010</P><P>03-2010</P><P>04-2011</P><P>...</P><P>Second table is like:</P><P>Name; Start Periode; Cost per Periode</P><P>Power ; 01-2010; 210</P><P>Water; 03-2010; 150</P><P>...</P><P></P><P>Now I need to join both Tables. I want the result-table to look like:</P><P>Periode; Costs; Name</P><P>01-2010; 210; Power</P><P>02-2010; 210; Power</P><P>03-2010; 210; Power</P><P>03-2010; 150; Water</P><P>04-2010; 210; Power</P><P>04-2010; 150; Water</P><P>...</P><P>Has anyone got a hint for me?</P><P>Thanks a lot ... Stefan</P></BODY></HTML> Tue, 27 Jul 2010 14:47:23 GMT https://community.qlik.com/t5/QlikView/Build-up-a-cross-table/m-p/234868#M86195 2010-07-27T14:47:23Z Build up a cross table https://community.qlik.com/t5/QlikView/Build-up-a-cross-table/m-p/234869#M86196 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 28 Jul 2010 10:21:52 GMT https://community.qlik.com/t5/QlikView/Build-up-a-cross-table/m-p/234869#M86196 2010-07-28T10:21:52Z