topic How to Transpose Need some help, hint would be fine in QlikView https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556209#M440796 <P>Have Transaction coming in the form below :</P><TABLE><TBODY><TR><TD>Transaction Data Model</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>WorkItem</TD><TD>Status</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>AssignedForWork</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>Work Complete</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>UnAssigned</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Sent to QA</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Work Complete</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Required Rework</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>AssignedForWork</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Outreach No</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Work Complete</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I transpose the data to look like in script&nbsp; or what is the best way If not one of the charts require data as in below format, Attached is PNG file<BR /><BR /><BR /><BR /><BR /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:15:08 GMT gopal5879 2024-11-16T21:15:08Z How to Transpose Need some help, hint would be fine https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556209#M440796 <P>Have Transaction coming in the form below :</P><TABLE><TBODY><TR><TD>Transaction Data Model</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>WorkItem</TD><TD>Status</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>AssignedForWork</TD><TD>&nbsp;</TD></TR><TR><TD>1</TD><TD>Work Complete</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>UnAssigned</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Sent to QA</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>Work Complete</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Required Rework</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>AssignedForWork</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Outreach No</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>Work Complete</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I transpose the data to look like in script&nbsp; or what is the best way If not one of the charts require data as in below format, Attached is PNG file<BR /><BR /><BR /><BR /><BR /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:15:08 GMT https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556209#M440796 gopal5879 2024-11-16T21:15:08Z Re: How to Transpose Need some help, hint would be fine https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556220#M440804 <P>Check the&nbsp;<A href="https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm" target="_self">Crosstable</A>&nbsp;statement</P> Wed, 13 Mar 2019 19:51:04 GMT https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556220#M440804 jwjackso 2019-03-13T19:51:04Z Re: How to Transpose Need some help, hint would be fine https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556336#M440868 Just elaborate more, it is easy I think. Yiu just want statuses in horizontal rows or what ? Thu, 14 Mar 2019 06:32:47 GMT https://community.qlik.com/t5/QlikView/How-to-Transpose-Need-some-help-hint-would-be-fine/m-p/1556336#M440868 Shubham_Deshmukh 2019-03-14T06:32:47Z