Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading different fields as one dimension

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:

CostumerJanFebMarAprilMaiJunJul
A10000200003200045000
B5200063000500452052015200
C52200.........
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

2 Replies
sunny_talwar

Check my response here

Loading data for pivot table

maxgro
MVP
MVP

try with crosstable

The Crosstable Load