topic Loop +Transpose in QlikView https://community.qlik.com/t5/QlikView/Loop-Transpose/m-p/566785#M211440 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P>I am stuck with a problem of looping sheets and workbooks and transposing the data in them. Just cannot find a solution.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>From my previous posts and checking out community I could manage to loop sheets and workbooks in one code and Transpose the values by writing another code. When I try to combine it I fail.</P><P>Please see attached .qvw and supporting data and also the edit script for reference.. Also attached a workbook with an output I want it to look like.</P><P></P><P>Data attached is just a sample. Have about 30 workbooks and each workbook has multiple sheets but the data structure is the same in all of them (same as the one attached).</P><P></P><P>I would be extremely grateful if someone can help me with this please.</P></BODY></HTML> Fri, 24 Jan 2014 18:40:49 GMT 2014-01-24T18:40:49Z Loop +Transpose https://community.qlik.com/t5/QlikView/Loop-Transpose/m-p/566785#M211440 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P>I am stuck with a problem of looping sheets and workbooks and transposing the data in them. Just cannot find a solution.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>From my previous posts and checking out community I could manage to loop sheets and workbooks in one code and Transpose the values by writing another code. When I try to combine it I fail.</P><P>Please see attached .qvw and supporting data and also the edit script for reference.. Also attached a workbook with an output I want it to look like.</P><P></P><P>Data attached is just a sample. Have about 30 workbooks and each workbook has multiple sheets but the data structure is the same in all of them (same as the one attached).</P><P></P><P>I would be extremely grateful if someone can help me with this please.</P></BODY></HTML> Fri, 24 Jan 2014 18:40:49 GMT https://community.qlik.com/t5/QlikView/Loop-Transpose/m-p/566785#M211440 2014-01-24T18:40:49Z