Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert table

Hi all,

How to convert my source excel table (table A) to qlikview table (Table B):

Table A:

AreaProduct201120122013
AX102030
AY51015
AZ204060

Table B:

AreaProductYearSales

A

X201110
AX201220
AX201330
AY20115
AY201210
AY201315
AZ201120
AZ201240
AZ201360

Thanks!

Zhou

1 Solution

Accepted Solutions
jchoucq
Partner - Creator II
Partner - Creator II

something like that :

TableB:

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Feuil1);

View solution in original post

7 Replies
jchoucq
Partner - Creator II
Partner - Creator II

hi Zhou,

when you load a file, you can make transformation on it.

In your case, in the wizard, you will have to use CrossTable !

Hope this helps

Johann

jchoucq
Partner - Creator II
Partner - Creator II

something like that :

TableB:

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Feuil1);

tresesco
MVP
MVP

Try like:

Crosstable (Year,Sales,2) Load * from <>;

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Zhou z,

PFA hope it will helps you.

Regards.,

Vishnu

Not applicable
Author

Hi Zhou,

Try to this statement ,

CrossTable(Year, Sales, 2)

LOAD Area,

     Product,

     [2011],

     [2012],

     [2013]

FROM

(ooxml, embedded labels, table is Sheet1);

suryanto89
Contributor III
Contributor III

Hi Zhou,

by doing this you should have Table B that you need.

CrossTable([2011], Sales, 2)

LOAD ARENA,

     PRODUCT,

     [2011],

     [2012],

     [2013]

FROM

..\Desktop\TEST.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards,

Not applicable
Author

Thanks for all your help. I have solved my problem. I ever thought that CrossTable wouldn't work for my institution.