topic Coloms to row in QlikView

Coloms to row

Wed, 25 Nov 2020 16:16:04 GMT

How can I transfert a number of columns to a row

Sctor1	Sector2	Sector3	Sector4	Sector 5
val1	val2	val1	val2	val2

I want get this:

oknotsen — Wed, 20 Apr 2016 11:29:58 GMT

By using the crosstable prefix to your load statement.

For detailed information, see here:

Chanty4u — Wed, 20 Apr 2016 12:25:27 GMT

chk dis too

sunny_talwar — Wed, 20 Apr 2016 12:27:32 GMT

I think in this case he would need a CrossTable Load as suggest by Onno van Knotsenburg

Chanty4u — Wed, 20 Apr 2016 12:28:38 GMT

sorry . just missed it

avinashelite — Wed, 20 Apr 2016 12:28:56 GMT

Try with crosstable () function

Crosstable

To turn a cross table into a straight table, you can use a crosstable prefix.

For a description of cross tables and how they can be handled in QlikView

The syntax is:

crosstable ( attribute field , data field [ , n ] )

( loadstatement | selectstatement )

where

attribute field is the field to contain the attribute values.

data field is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed

to generic form. Default is 1.

Examples:

Crosstable (Month,Sales) Load * from ex1.csv;

Crosstable (Month,Sales,2) Load * from ex2.csv;

Crosstable (A,B) Select * from table3;

Wed, 20 Apr 2016 12:42:43 GMT

thanks a lot I do it and it work well as Chanty 4y.

avinashelite — Wed, 20 Apr 2016 12:43:15 GMT

if you have got the answer please mark the helpful and correct answers and close this thread