Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data in this format.
Have to produce result like this below:
any help is much appreciated. thanks
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
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 |
Hello @ram23, would it be possible that you share a .qvf example so I can try it on my end? Thank you!