Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
gopal5879
New Contributor III

How to Transpose Need some help, hint would be fine

Have Transaction coming in the form below :

Transaction Data Model  
WorkItemStatus 
1AssignedForWork 
1Work Complete 
2UnAssigned 
2Sent to QA 
2Work Complete 
3Required Rework 
3AssignedForWork 
3Outreach No 
3Work Complete 

 

How can I transpose the data to look like in script  or what is the best way If not one of the charts require data as in below format, Attached is PNG file




 

 

 

 

2 Replies
jwjackso
Valued Contributor

Re: How to Transpose Need some help, hint would be fine

Check the Crosstable statement

Shubham_Deshmukh
Valued Contributor

Re: How to Transpose Need some help, hint would be fine

Just elaborate more, it is easy I think. Yiu just want statuses in horizontal rows or what ?