Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ram23
Contributor
Contributor

Want to transpose table (date columns) in qlik sense

I have data in this format.  

ram23_0-1640699087084.pngHave to produce result like this below:

ram23_1-1640699114324.png

any help is much appreciated. thanks

3 Replies
Patricia_Silva
Specialist II
Specialist II

Hello @ram23, thank you for posting to our Qlik Community! Would that work for what you want to achieve? https://community.qlik.com/t5/New-to-Qlik-Sense/Transpose-Table/td-p/1448316

Help users find answers! Don't forget to mark a correct resolution 🙂
ram23
Contributor
Contributor
Author

Thanks.  This is similar, but not exactly. 

I have 4 cr columns in this format 

Part Suplr Recv_loc Pgm q_rel_suplr_mo1 d_rel_suplr_mo1 q_rel_suplr_mo2 d_rel_suplr_mo2 q_rel_suplr_mo3 d_rel_suplr_mo3 q_rel_suplr_mo4 d_rel_suplr_mo4 q_rel_suplr_mo5 d_rel_suplr_mo5
68432342AA 23621 4015 98 10 10/31/2021 0 11/1/2021 43 12/6/2021 185 1/3/2022 214 2/7/2022

 

Want to display like this:

Part Suplr Recv_loc Pgm Oct-21 Nov-21 Dec-21 Jan-22 Feb-22
68432342AA 23621 4015 98 0 915 43 185 214
Patricia_Silva
Specialist II
Specialist II

Hello @ram23, would it be possible that you share a .qvf example so I can try it on my end? Thank you!

Help users find answers! Don't forget to mark a correct resolution 🙂