Re: trying to convert row to column - Qlik Community

Report Inappropriate Content · ‎2014-02-28

I am new to qlikview. I want convert a row to column.

The input is like this-

column1 companycode1 column2 companycode2 companycode3.......companycode12

a

b

c

d

e

My output should be like:

a b

companycode company name 1 2 3 4 5 1 2 3 4 5 column2

companycode1 cn1

companycode2 cn2

companycode3 cn3

I have another file which is

companycode company name

companycode2 cn2

companycode3 cn3

....

tresesco · ‎2014-02-28

Learn and try CROSSTABLE

vikasmahajan · ‎2014-02-28

PFA Sample application for Cross Table.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-02-28

Trying using a Pivot table and then hold press the columns to get the blue line and then drag and drop accordingly.

Thanks,

Angad

Report Inappropriate Content · ‎2014-02-28

Hi if you are showing in pivot table just drag and drop that field otherwise go for cross table

PrashantSangle · ‎2014-02-28

Hi,

while loading data got to rotate tab->Transpose.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-02-28

When I am using crosstable, column2 also comes under company codes...

but I want column2 as a saperate column..