topic Re: Expression Columns into rows in QlikView

Expression Columns into rows

mohanrajsubrama — Fri, 28 Dec 2012 05:26:36 GMT

Hi Guys,

I have a Table in this format.

country	gender	current year	previous year	change in %
poland	male	1000000	800000	20
	female	60000	40000	33

But my Client requirement should be in this format.when i drag the expressions into rows the table gets crossed.

country	years	male	female
poland	current year	1000000	60000
	previous year	800000	40000
	change in %	20	33

here for current year,previous and % change were three different expressions.how can i acheive this any suggestions.

Regards,

Mohanraj Subramanian.

Re: Expression Columns into rows

nirav_bhimani — Fri, 28 Dec 2012 05:57:33 GMT

HI,

For that I think you have to use crosstable concept in script and also calculate all the Expression in script level.

Regards,

Nirav Bhimani

Re: Expression Columns into rows

neha_shirsath — Fri, 28 Dec 2012 06:24:40 GMT

Hii,

Please find the attachment.Hope it will help you.

Re: Expression Columns into rows

mohanrajsubrama — Fri, 28 Dec 2012 07:25:40 GMT

Hi Guys,

Thanks for ur Quick Reply.Its working fine now.

Regards,

Mohanraj Subramanian.

Re: Expression Columns into rows

Fri, 28 Dec 2012 07:49:17 GMT

this code also helps you in future

LOAD country,

gender,

[current year],

[previous year],

[change in %]

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD 'current year' as years,[current year] as male,[current year] as female

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate LOAD 'previous year' as years,[previous year] as male,[previous year] as female

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate LOAD 'change in %' as years,[change in %] as male,[change in %] as female

FROM

C:\Users\Desktop\test28.xlsx

(ooxml, embedded labels, table is Sheet1);

thanks.