Discussion Board for collaboration related to QlikView App Development.
Hello,Im trying to load an excel spreadsheet with data but need to transpose some of columns so I get a really simple table in qlik, is this possible?
Thanks in advance
Try using Crosstable()
LOAD * Inline [
Field 1,Field 2,Field 3,Jan,Feb,Mar,Apr
a, d, g, 1, 2, 5, 1
b, e, h, 7, 3, 2, 4
c, f, i, 4, 8, 2, 4]
View solution in original post
Briiliant, really helpful. Is there anyway I can change the month field as its pulling through as a numberic field?
I'm sorry, but I don't really understand your issue. Could you try to post a picture or explain again in other words?