Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a query related to Qliksense.
I want to convert below data, which I receive in excel (It's a pivot table output but I don't have the access to raw data) :
Row Labels | Jan | Feb | Mar | Apr | May | Jun | Jul |
A | 458 | 776 | 932 | 846 | 872 | 569 | 932 |
B | 920 | 771 | 319 | 601 | 346 | 923 | 174 |
C | 375 | 736 | 184 | 267 | 586 | 556 | 870 |
D | 285 | 911 | 785 | 601 | 195 | 599 | 740 |
E | 804 | 708 | 816 | 995 | 165 | 788 | 896 |
F | 555 | 500 | 874 | 781 | 231 | 936 | 538 |
G | 463 | 617 | 264 | 422 | 320 | 314 | 899 |
H | 478 | 919 | 844 | 106 | 789 | 468 | 336 |
I | 801 | 689 | 494 | 115 | 103 | 381 | 111 |
J | 612 | 473 | 891 | 920 | 638 | 410 | 631 |
I want to convert it to below:
.
.
.
till Dec.
I tried reading solution on:
https://community.qlik.com/thread/112003
but content is not available,
then I went through generic load:
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470
It was helpful but the output I am looking for is opposite of it.
Please suggest!
Crosstable and Generic Loads are opposites, so this should be what you're after.