topic Re: Crosstable in QlikView

Crosstable

pmezagamsa — Thu, 23 Nov 2017 20:43:34 GMT

Hello everyone,

I have the following problem, in Qlik I do not know how to change the format of my TEST file, to obtain as a result the form that comes in the image below.

Thank you for your attention.

Re: Crosstable

woshua5550 — Fri, 24 Nov 2017 14:54:00 GMT

you want to transpose whole table ,right ? try this

LOAD * FROM

TEST.xlsx

(ooxml, embedded labels, table is Hoja1, filters(Transpose()));

Re: Crosstable

petter — Fri, 24 Nov 2017 16:03:14 GMT

How do you want the rows with per hour numbers to be handled? Will a pure transpose work for you?

Normally an Unpivot would be the better representation/transformation for a BI application.

Re: Crosstable

pmezagamsa — Fri, 24 Nov 2017 16:15:57 GMT

Hi Dave, send me this message error.

Thank you for help me.

Re: Crosstable

pmezagamsa — Fri, 24 Nov 2017 16:32:16 GMT

Hi Petter, i try to preserve the format of file TEST on Qlik, because the row FECHA=DATE will be the header after transpose and date is the master measure.

I try with Unpivot but, i can´t obtain the result.

Thank you for the help.

Best regards

Re: Crosstable

woshua5550 — Mon, 27 Nov 2017 04:19:48 GMT

How about Load * ?

it looks ok in my side

Re: Crosstable

pmezagamsa — Mon, 27 Nov 2017 20:57:53 GMT

Fast and esy Dave.

Thank you for the help