Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Partner

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