Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 🙂