https://community.qlik.com/t5/QlikView/Transpose-table/m-p/2051791#M1223015 <P><SPAN>Hi All,</SPAN></P> <P><SPAN>I would like to transpose the rows of a table to columns I currently have the following information:</SPAN></P> <TABLE border="1"> <TBODY> <TR> <TD width="50%">Attribute</TD> <TD width="50%">Value</TD> </TR> <TR> <TD width="50%">ID</TD> <TD width="50%">1</TD> </TR> <TR> <TD width="50%">Code</TD> <TD width="50%">1233</TD> </TR> <TR> <TD width="50%">Week</TD> <TD width="50%">1</TD> </TR> <TR> <TD width="50%">Sales</TD> <TD width="50%">132</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But I need the information as follows</P> <TABLE border="1"> <TBODY> <TR> <TD width="20%">Id</TD> <TD width="20%">Code</TD> <TD width="20%">Week 1</TD> <TD width="20%">Week 2</TD> <TD width="20%">Week 3</TD> </TR> <TR> <TD>1</TD> <TD>1233</TD> <TD>132</TD> <TD>134</TD> <TD>135</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The value included in the weeks corresponds to the value of sales</P> <P>I'd greatly appreciate some insight on how to deal with this in QlikSense.</P> <P>Many thanks,</P> Tue, 21 Mar 2023 22:28:46 GMT jvelasqu3 2023-03-21T22:28:46Z https://community.qlik.com/t5/QlikView/Transpose-table/m-p/2051791#M1223015 <P><SPAN>Hi All,</SPAN></P> <P><SPAN>I would like to transpose the rows of a table to columns I currently have the following information:</SPAN></P> <TABLE border="1"> <TBODY> <TR> <TD width="50%">Attribute</TD> <TD width="50%">Value</TD> </TR> <TR> <TD width="50%">ID</TD> <TD width="50%">1</TD> </TR> <TR> <TD width="50%">Code</TD> <TD width="50%">1233</TD> </TR> <TR> <TD width="50%">Week</TD> <TD width="50%">1</TD> </TR> <TR> <TD width="50%">Sales</TD> <TD width="50%">132</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But I need the information as follows</P> <TABLE border="1"> <TBODY> <TR> <TD width="20%">Id</TD> <TD width="20%">Code</TD> <TD width="20%">Week 1</TD> <TD width="20%">Week 2</TD> <TD width="20%">Week 3</TD> </TR> <TR> <TD>1</TD> <TD>1233</TD> <TD>132</TD> <TD>134</TD> <TD>135</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The value included in the weeks corresponds to the value of sales</P> <P>I'd greatly appreciate some insight on how to deal with this in QlikSense.</P> <P>Many thanks,</P> Tue, 21 Mar 2023 22:28:46 GMT https://community.qlik.com/t5/QlikView/Transpose-table/m-p/2051791#M1223015 jvelasqu3 2023-03-21T22:28:46Z https://community.qlik.com/t5/QlikView/Transpose-table/m-p/2051803#M1223016 <P>Hi,</P> <P>This issue should be solved with the Generic prefix, but the example you have shown is missing part of the data. We need 3 parts to do this transformation. Entity-Attribute -Value.&nbsp; Do you also have the entity ?</P> Wed, 22 Mar 2023 00:01:08 GMT https://community.qlik.com/t5/QlikView/Transpose-table/m-p/2051803#M1223016 Lisa_P 2023-03-22T00:01:08Z