How to transpose rows and columns in Qlikview

[jleefjcapital]

I am trying to generate a transpose step in Qlikview, which I can use in Qliksense.   I'm not sure how  to go about generating this.  The date file I'm using is an Excel file, and I've attached for your reference.

Currently, each year is a column, but I would like to create a new column for Year and display it vertically.

[trdandamudi]

May be as below:

Data:

CrossTable (Year,Sales,1)

LOAD GeoName,

     [2001],

     [2002],

     [2003],

     [2004]

FROM

[..\..\..\Temp\TodayTestFile.xlsx]          '<------ Update with your file location here

(ooxml, embedded labels, table is Sheet1);

Note:

Your Excel file has lot of data, so I created a sample excel file as below for the above code:

GeoName	2001	2002	2003	2004
United States (Metropolitan Portion)	100	101	102	103
Abilenem, TX (Metropolitan Statistical Area)	200	201	202	203
Abilenem, OH (Metropolitan Statistical Area)	300	301	302	303

[#3]

Hi Jes

This will help you out.

Cross Table in QlikView - YouTube

-Ashok