https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518572#M106121 <P>&nbsp;</P><P>My input table has Resource types, companies and week numbers showing allocation of resources. I need to load the data so that I can chart by week the number of resources by type and company. I've tried using Crosstable but as I have more than one column I need to include I'm not getting the results I need.</P><P>The table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="orangebloss_0-1747900608779.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180664i90692F2FE1441E3E/image-size/medium?v=v2&amp;px=400" role="button" title="orangebloss_0-1747900608779.png" alt="orangebloss_0-1747900608779.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>The required result:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="orangebloss_1-1747900640593.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180665iBE844E79036D20F7/image-size/medium?v=v2&amp;px=400" role="button" title="orangebloss_1-1747900640593.png" alt="orangebloss_1-1747900640593.png" /></span></P><P>&nbsp;</P> Thu, 22 May 2025 07:57:34 GMT orangebloss 2025-05-22T07:57:34Z https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518572#M106121 <P>&nbsp;</P><P>My input table has Resource types, companies and week numbers showing allocation of resources. I need to load the data so that I can chart by week the number of resources by type and company. I've tried using Crosstable but as I have more than one column I need to include I'm not getting the results I need.</P><P>The table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="orangebloss_0-1747900608779.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180664i90692F2FE1441E3E/image-size/medium?v=v2&amp;px=400" role="button" title="orangebloss_0-1747900608779.png" alt="orangebloss_0-1747900608779.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>The required result:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="orangebloss_1-1747900640593.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180665iBE844E79036D20F7/image-size/medium?v=v2&amp;px=400" role="button" title="orangebloss_1-1747900640593.png" alt="orangebloss_1-1747900640593.png" /></span></P><P>&nbsp;</P> Thu, 22 May 2025 07:57:34 GMT https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518572#M106121 orangebloss 2025-05-22T07:57:34Z https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518581#M106124 <P>Have you tried to follow "Example 3" in the <A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm" target="_self">documentation for crosstable</A>?</P> Thu, 22 May 2025 08:54:04 GMT https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518581#M106124 henrikalmen 2025-05-22T08:54:04Z https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518592#M106126 <P>Hi, you can still use crosstable to achieve the desired result, you just need to leave the first two column.<BR />here is the script that would work for you:</P><DIV><STRONG>CrossTable(Week, Allocation, 2) </STRONG>// here 2 represent the no of column you want to skip.</DIV><P>&nbsp;</P><P>Best Regards,</P><P>Sayed Mannan Ahmad</P> Thu, 22 May 2025 09:16:28 GMT https://community.qlik.com/t5/App-Development/Converting-columns-to-rows-with-multiple-fields/m-p/2518592#M106126 Sayed_Mannan 2025-05-22T09:16:28Z