Data Transformation in Qliksense

[Hemachandran1]

Hi Team,

I need to transform the below data.

Required Output:

Can you please help on transformation data in Qlik sense Script.

[justISO]

Hi, try to use Crosstable approach. More details:

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix... 

[ed4k2]

Hello Hemachandran1,

You can build your chart with this 2 simple steps. Step #1 will remain in your load script.

1. build the wide table with many columns, for example,
   1. Reporting Item | BR | Period | Amt
   2. Net | Home | Jan | 83,988
   3. Net | Acute | Jan | 31,374
   4. Net | Acute Care SV | Jan | 2,857
   5. Net | Pre-Hospital | Jan | 18,998
   6. ..
   7. ..
   8. ..
   9. ..
   10. Net Assets | Home | Jan | 19,975
   11. Net Assets | Acute | Jan | -422
   12. ..
2. then build the pivot table with the transformed table