https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2092300#M89526 <P>I have Calendar Table where I have Retail week as column where we have all retail week. Can we use this column to get Final table.</P> Tue, 11 Jul 2023 01:02:17 GMT Ipsita20191 2023-07-11T01:02:17Z https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2091960#M89509 <P>Hi All,</P> <P>Can you please help me on this issue I am facing.</P> <P>Input Table:</P> <TABLE style="border-collapse: collapse; width: 192pt;" border="0" width="256" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" class="xl63" style="height: 15.0pt; width: 48pt;">Pkey</TD> <TD width="64" class="xl63" style="border-left: none; width: 48pt;">Startweek</TD> <TD width="64" class="xl63" style="border-left: none; width: 48pt;">EndWeek</TD> <TD width="64" class="xl63" style="border-left: none; width: 48pt;">Value</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">1</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202203</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202205</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">22</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">1</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202208</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202210</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">11</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">1</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202215</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202217</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" align="right" class="xl63" style="height: 15.0pt; border-top: none;">2</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202203</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">202205</TD> <TD align="right" class="xl63" style="border-top: none; border-left: none;">33</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want data set as like this:</P> <TABLE style="border-collapse: collapse; width: 144pt;" border="0" width="192px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" class="xl65" style="height: 15.0pt; width: 48pt;">Pkey</TD> <TD width="63.9062px" class="xl65" style="border-left: none; width: 48pt;">Week</TD> <TD width="63.7604px" class="xl65" style="border-left: none; width: 48pt;">Value</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202203</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">22</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202204</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">22</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202205</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">22</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202208</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">11</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202209</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">11</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202210</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">11</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202215</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">10</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202216</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">10</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">1</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202217</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">10</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">2</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202203</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">33</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">2</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202204</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">33</TD> </TR> <TR style="height: 15.0pt;"> <TD width="63.6667px" height="20" align="right" class="xl65" style="height: 15.0pt; border-top: none;">2</TD> <TD width="63.9062px" align="right" class="xl65" style="border-top: none; border-left: none;">202205</TD> <TD width="63.7604px" align="right" class="xl65" style="border-top: none; border-left: none;">33</TD> </TR> </TBODY> </TABLE> Fri, 15 Nov 2024 21:36:16 GMT https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2091960#M89509 Ipsita20191 2024-11-15T21:36:16Z https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2091976#M89511 <P>Can you guys help me on this , As it is bit urgent.. I know I have posted few times back. Your help is much appreciated.</P> Mon, 10 Jul 2023 08:26:48 GMT https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2091976#M89511 Ipsita20191 2023-07-10T08:26:48Z https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2092300#M89526 <P>I have Calendar Table where I have Retail week as column where we have all retail week. Can we use this column to get Final table.</P> Tue, 11 Jul 2023 01:02:17 GMT https://community.qlik.com/t5/App-Development/Convert-data-from-columns-to-rows-in-Qlik-sense/m-p/2092300#M89526 Ipsita20191 2023-07-11T01:02:17Z