Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

pmezagamsa
New Contributor II

Crosstable

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.

Captura.PNG

Thank you for your attention.

Tags (1)
6 Replies
woshua5550
Contributor III

Re: Crosstable

you want to transpose whole table ,right ? try this

LOAD * FROM

TEST.xlsx

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

MVP
MVP

Re: Crosstable

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.

pmezagamsa
New Contributor II

Re: Crosstable

Hi Dave, send me this message error.

Thank you for help me.

Error1.PNG

pmezagamsa
New Contributor II

Re: Crosstable

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

PM

Highlighted
woshua5550
Contributor III

Re: Crosstable

How about Load * ?

it looks ok in my side

微信截图_20171127121921.png

pmezagamsa
New Contributor II

Re: Crosstable

Fast and esy Dave.

Thank you for the help