topic Re: Transpose and Cross in QlikView

T

help4qv123 — Tue, 24 Mar 2015 15:12:24 GMT

Re: Transpose and Cross

prieper — Tue, 24 Mar 2015 15:40:52 GMT

not clear, what you wish to achieve,

can you also post the desired result?

Peter

Re: Transpose and Cross

help4qv123 — Wed, 25 Mar 2015 04:37:36 GMT

Hi i am aching a sample with my data and result which i need....

Re: Transpose and Cross

prma7799 — Wed, 25 Mar 2015 05:21:52 GMT

You need output as below only two rows?

Class	A	B	C	D	E	F
Sum(data)	3691	8005	1151	1801	1141	200

Re: Transpose and Cross

help4qv123 — Wed, 25 Mar 2015 05:53:55 GMT

with other filters

Re: Transpose and Cross

Anonymous — Wed, 25 Mar 2015 06:33:44 GMT

Can you upload sample QVW

Re: Transpose and Cross

prieper — Wed, 25 Mar 2015 08:34:01 GMT

Is it something like (with offset)

LOAD Metel,

Algeria,

Del,

Calcata,

Data AS R1, // or [Class A]

Data1 AS R2, // or [Class B]

Data2 AS R3,

Data3 AS R4,

Data4 AS R5,

Data5 AS R6

FROM

[....\sample (3).xlsx]

(ooxml, embedded labels, header is 3 lines, table is Sheet1);

Or do you need to have the data normalized (CROSSTABLE)?

Peter

Re: Transpose and Cross

help4qv123 — Wed, 25 Mar 2015 08:44:46 GMT

yes i need it normalised....

Re: Transpose and Cross

prieper — Wed, 25 Mar 2015 08:50:12 GMT

this way?

CROSSTABLE (Class, Data, 4) LOAD Metel,

Algeria,

Del,

Calcata,

Data AS R1, // or [Class A]

Data1 AS R2, // or [Class B]

Data2 AS R3,

Data3 AS R4,

Data4 AS R5,

Data5 AS R6

FROM

(ooxml, embedded labels, header is 3 lines, table is Sheet1);

Peter

Re: Transpose and Cross

jpenuliar — Wed, 25 Mar 2015 09:14:28 GMT

Hi,

The scenario you have mentioned isn't very clear, Can you post another excel sample where you have on 1 sheet the original data (or sample) then on the next sheet the transposed table you would expect, then on another sheet the cross.

As the saying goes, a picture paints...

Re: Transpose and Cross

Anonymous — Wed, 25 Mar 2015 09:35:49 GMT

Try this one attached