Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am more or less new to Qlik Sense, already did some tutorials but I am wondering, whether QLIK can handle my data (I think it can).
I have excel sheets, that look e.g. like this:
Costumer | Jan | Feb | Mar | April | Mai | Jun | Jul |
---|---|---|---|---|---|---|---|
A | 10000 | 20000 | 32000 | 45000 | |||
B | 52000 | 63000 | 500 | 4520 | 5201 | 5200 | |
C | 52200 | ......... | |||||
D |
So what I am wondering is, how can I load my dates (Jan-Jul) as one dimension. I was thinking about using Pivot analysis, but that's unfortunately not answering my question on how to load my data properly.
Thanks for the answers,
Tom
Check my response here
try with crosstable