topic Re: Columns to Rows in QlikView

Columns to Rows

Fri, 27 Jan 2012 09:30:37 GMT

Hi All,

I have a spreadsheet like below

Region	Month1	Month2	Month3	Month4
Region	Client	Client	Client	Client
Region	Client	Client	Client	Client

From this spreadsheet I would like to create a single table with the following Structure:

The main problem I am facing is getting the month columns to rows into a single Months column.

Any suggestions would be appreciated?

Thank you,

lironbaram — Fri, 27 Jan 2012 09:46:05 GMT

try this one hope it helps you

rohit214 — Fri, 27 Jan 2012 09:59:18 GMT

try this

crosstable(Months,Clients)

load

Regoin,

Month1,

Month2,

from

xyz.qvd;

Hope it helps you

thanks

rohit

Fri, 27 Jan 2012 10:13:27 GMT

Thanks Liron and Rohit. Both examples worked perfectly.

Regards GJ.