topic Re: Cross Table or something else? in QlikView

Cross Table or something else?

bazzaonline — Tue, 28 Jan 2020 12:53:03 GMT

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?

Excel Input
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


Qlik Table
Field 1
Field 2
Field 3
Months

Thanks in advance

Re: Cross Table or something else?

Vegar — Tue, 28 Jan 2020 13:28:17 GMT

Try using Crosstable()

CrossTable(Month, Value,3) 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] ;

Re: Cross Table or something else?

bazzaonline — Tue, 28 Jan 2020 13:42:06 GMT

Briiliant, really helpful. Is there anyway I can change the month field as its pulling through as a numberic field?

Re: Cross Table or something else?

Vegar — Tue, 28 Jan 2020 16:08:31 GMT

I'm sorry, but I don't really understand your issue. Could you try to post a picture or explain again in other words?