topic Transform Excel File in QlikView https://community.qlik.com/t5/QlikView/Transform-Excel-File/m-p/235759#M87007 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I need to do create a chart out of an excel file:</P><P>The Excel File looks like this:</P><P></P><P>yearmonth | category1_actual | catregory1_plan| category2_actual | category2_plan | categeory3_actual....</P><P>can someone give me an advise whats the best way to transform the table so that the result chart (pivot) is looking this way:</P><P>category | yearmonth | acutal | plan<BR />1...<BR />2...<BR />3...</P><P>At first I thought about load yearmonth and categoryX_actual and plan for each category witth an addtional field that contains the category ('category1'), and concatenate them so I can use category as a dimension.</P><P>Thanks for your help in advance.</P><P>Aloah<BR /></P></BODY></HTML> Sun, 09 May 2010 14:52:27 GMT 2010-05-09T14:52:27Z Transform Excel File https://community.qlik.com/t5/QlikView/Transform-Excel-File/m-p/235759#M87007 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I need to do create a chart out of an excel file:</P><P>The Excel File looks like this:</P><P></P><P>yearmonth | category1_actual | catregory1_plan| category2_actual | category2_plan | categeory3_actual....</P><P>can someone give me an advise whats the best way to transform the table so that the result chart (pivot) is looking this way:</P><P>category | yearmonth | acutal | plan<BR />1...<BR />2...<BR />3...</P><P>At first I thought about load yearmonth and categoryX_actual and plan for each category witth an addtional field that contains the category ('category1'), and concatenate them so I can use category as a dimension.</P><P>Thanks for your help in advance.</P><P>Aloah<BR /></P></BODY></HTML> Sun, 09 May 2010 14:52:27 GMT https://community.qlik.com/t5/QlikView/Transform-Excel-File/m-p/235759#M87007 2010-05-09T14:52:27Z Transform Excel File https://community.qlik.com/t5/QlikView/Transform-Excel-File/m-p/235760#M87008 <HTML><HEAD></HEAD><BODY><P>See "CrossTable" in the QV Ref Guide.</P><P>-Rob</P></BODY></HTML> Sun, 09 May 2010 22:23:43 GMT https://community.qlik.com/t5/QlikView/Transform-Excel-File/m-p/235760#M87008 rwunderlich 2010-05-09T22:23:43Z