Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Vertical data to horizontal format (Transpose of data)

Hi All,

I have data in the spreadsheet, 1st column should be considered as a dimension. Alongside's columns data should belong to the particular dimension.

 

Given Input:

Filedsdatadata1
nameabcbcd
lastnameab
DOB10-09-199316-06-1996
DesignationManagerdeveloper

 

Desired Output:

namelastnameDOBDesignation
abca10-09-1993Manager
bcdb16-06-1996developer

 

Thanks in advance 

8 Replies
Highlighted
Master
Master

Re: Vertical data to horizontal format (Transpose of data)

from

Given Input in excel for example

Filedsdatadata1
nameabcbcd
lastnameab
DOB10-09-199316-06-1996
DesignationManagerdeveloper
   

then :

Sans titre.png

output :

Capture.JPG

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
Highlighted
Contributor II
Contributor II

Re: Vertical data to horizontal format (Transpose of data)

Hi,

 

Require the solution for Qliksense. 

Thank you.

Highlighted
Master
Master

Re: Vertical data to horizontal format (Transpose of data)

juste try to copy and paste the code and define the path to the data.

attached the Qliksense version

Capture.JPG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
Highlighted
Specialist II
Specialist II

Re: Vertical data to horizontal format (Transpose of data)

Hi,

Maybe you can use crosstable.

 

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

 

i.e

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

Highlighted
Partner
Partner

Re: Vertical data to horizontal format (Transpose of data)

Hi,

Thanks for the solution.

If we are fetching the data from the source system(SQL) how it is possible.

Highlighted
Contributor
Contributor

Re: Vertical data to horizontal format (Transpose of data)

When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa.

Highlighted
Specialist II
Specialist II

Re: Vertical data to horizontal format (Transpose of data)

Looks like the attached solution works only when the source is excel, is there any alternative solution for this issue?

Highlighted
Specialist II
Specialist II

Re: Vertical data to horizontal format (Transpose of data)

First extract the data to create your aux table, after apply Crosstable  on it, I think that will be the  easier way