https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520630#M106447 <P>Hello Hemachandran1,</P> <P>You can build your chart with this 2 simple steps. Step #1 will remain in your load script.</P> <OL> <LI>build the wide table with many columns, for example, <OL> <LI>Reporting Item | BR | Period | Amt</LI> <LI>Net | Home | Jan | 83,988</LI> <LI>Net | Acute | Jan | 31,374</LI> <LI>Net | Acute Care SV | Jan | 2,857</LI> <LI>Net | Pre-Hospital | Jan | 18,998</LI> <LI>..</LI> <LI>..</LI> <LI>..</LI> <LI>..</LI> <LI>Net Assets | Home | Jan | 19,975</LI> <LI>Net Assets | Acute | Jan | -422</LI> <LI>..</LI> </OL> </LI> <LI>then build the pivot table with the transformed table</LI> </OL> Mon, 09 Jun 2025 16:37:12 GMT ed4k2 2025-06-09T16:37:12Z https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520486#M106427 <P>Hi Team,</P><P>I need to transform the below data.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hemachandran1_0-1749351733366.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/181143iA4D193F8B5FEE8CE/image-size/medium?v=v2&amp;px=400" role="button" title="Hemachandran1_0-1749351733366.png" alt="Hemachandran1_0-1749351733366.png" /></span></P><P>Required Output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hemachandran1_0-1749352438437.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/181144iEBFA4E134CAD9EEF/image-size/medium?v=v2&amp;px=400" role="button" title="Hemachandran1_0-1749352438437.png" alt="Hemachandran1_0-1749352438437.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Can you please help on transformation data in Qlik sense Script.</P> Sun, 08 Jun 2025 03:14:33 GMT https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520486#M106427 Hemachandran1 2025-06-08T03:14:33Z https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520545#M106434 <P>Hi, try to use Crosstable approach. More details:</P><P><A href="https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm" target="_blank">https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm</A>&nbsp;</P> Mon, 09 Jun 2025 09:47:42 GMT https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520545#M106434 justISO 2025-06-09T09:47:42Z https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520630#M106447 <P>Hello Hemachandran1,</P> <P>You can build your chart with this 2 simple steps. Step #1 will remain in your load script.</P> <OL> <LI>build the wide table with many columns, for example, <OL> <LI>Reporting Item | BR | Period | Amt</LI> <LI>Net | Home | Jan | 83,988</LI> <LI>Net | Acute | Jan | 31,374</LI> <LI>Net | Acute Care SV | Jan | 2,857</LI> <LI>Net | Pre-Hospital | Jan | 18,998</LI> <LI>..</LI> <LI>..</LI> <LI>..</LI> <LI>..</LI> <LI>Net Assets | Home | Jan | 19,975</LI> <LI>Net Assets | Acute | Jan | -422</LI> <LI>..</LI> </OL> </LI> <LI>then build the pivot table with the transformed table</LI> </OL> Mon, 09 Jun 2025 16:37:12 GMT https://community.qlik.com/t5/App-Development/Data-Transformation-in-Qliksense/m-p/2520630#M106447 ed4k2 2025-06-09T16:37:12Z