topic Crosstable/For loop Question in QlikView https://community.qlik.com/t5/QlikView/Crosstable-For-loop-Question/m-p/1323511#M614270 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I have a big table consisting of multiple header items that i need to consolidate by months. I know I can do this in several ways, but my code is long and manual and I was hoping one of the geniuses here could help me learn a better way.</P><P></P><P>My table has the following fields.</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>ID</P> <P>Name</P> <P>Title</P> <P>SalesAug</P> <P>SalesSep</P> <P>SalesOct</P> <P>SalesNov</P> <P>SalesDec</P> <P>SalesJan<BR />SalesFeb</P> <P>SalesMar</P> <P>SalesMay</P> <P>SalesJun</P> <P>SalesJul</P> <P>HoursAug</P> <P>HoursSep</P> <P>HoursOct</P> <P>HoursNov</P> <P>HoursDec</P> <P>HoursJan<BR />HoursFeb</P> <P>HoursMar</P> <P>HoursMay</P> <P>HoursJun</P> <P>HoursJul</P> <P>BonusAug</P> <P>BonusSep</P> <P>BonusOct</P> <P>BonusNov</P> <P>BonusDec</P> <P>BonusJan<BR />BonusFeb</P> <P>BonusMar</P> <P>BonusMay</P> <P>BonusJun</P> <P>BonusJul</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Is there a clean way I can make this into a table with the following fields:</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>ID</P> <P>Name</P> <P>Title</P> <P>Month</P> <P>Sales</P> <P>Hours</P> <P>Bonus</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Any help is appreciated</P></BODY></HTML> Mon, 31 Jul 2017 21:33:50 GMT Anonymous 2017-07-31T21:33:50Z Crosstable/For loop Question https://community.qlik.com/t5/QlikView/Crosstable-For-loop-Question/m-p/1323511#M614270 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I have a big table consisting of multiple header items that i need to consolidate by months. I know I can do this in several ways, but my code is long and manual and I was hoping one of the geniuses here could help me learn a better way.</P><P></P><P>My table has the following fields.</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>ID</P> <P>Name</P> <P>Title</P> <P>SalesAug</P> <P>SalesSep</P> <P>SalesOct</P> <P>SalesNov</P> <P>SalesDec</P> <P>SalesJan<BR />SalesFeb</P> <P>SalesMar</P> <P>SalesMay</P> <P>SalesJun</P> <P>SalesJul</P> <P>HoursAug</P> <P>HoursSep</P> <P>HoursOct</P> <P>HoursNov</P> <P>HoursDec</P> <P>HoursJan<BR />HoursFeb</P> <P>HoursMar</P> <P>HoursMay</P> <P>HoursJun</P> <P>HoursJul</P> <P>BonusAug</P> <P>BonusSep</P> <P>BonusOct</P> <P>BonusNov</P> <P>BonusDec</P> <P>BonusJan<BR />BonusFeb</P> <P>BonusMar</P> <P>BonusMay</P> <P>BonusJun</P> <P>BonusJul</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Is there a clean way I can make this into a table with the following fields:</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>ID</P> <P>Name</P> <P>Title</P> <P>Month</P> <P>Sales</P> <P>Hours</P> <P>Bonus</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Any help is appreciated</P></BODY></HTML> Mon, 31 Jul 2017 21:33:50 GMT https://community.qlik.com/t5/QlikView/Crosstable-For-loop-Question/m-p/1323511#M614270 Anonymous 2017-07-31T21:33:50Z