Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pmezagamsa
Contributor II
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.

6 Replies
woshua5550
Creator III
Creator III

you want to transpose whole table ,right ? try this

LOAD * FROM

TEST.xlsx

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

petter
Partner - Champion III
Partner - Champion III

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
Contributor II
Contributor II
Author

Hi Dave, send me this message error.

Thank you for help me.

Error1.PNG

pmezagamsa
Contributor II
Contributor II
Author

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

woshua5550
Creator III
Creator III

How about Load * ?

it looks ok in my side

微信截图_20171127121921.png

pmezagamsa
Contributor II
Contributor II
Author

Fast and esy Dave.

Thank you for the help