Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Specialist II
Specialist II

Check the Crosstable statement

Highlighted
Specialist
Specialist

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