Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
help4qv123
Contributor

T

hi

10 Replies
prieper
Honored Contributor II

Re: Transpose and Cross

not clear, what you wish to achieve,

can you also post the desired result?

Peter

help4qv123
Contributor

Re: Transpose and Cross

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

prma7799
Honored Contributor III

Re: Transpose and Cross

You need output as below only two rows?

 

ClassABCDEF
Sum(data)36918005115118011141200
help4qv123
Contributor

Re: Transpose and Cross

with other filters

bhagirath
Contributor III

Re: Transpose and Cross

Can you upload sample QVW

prieper
Honored Contributor II

Re: Transpose and Cross

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

help4qv123
Contributor

Re: Transpose and Cross

yes i need it normalised....

prieper
Honored Contributor II

Re: Transpose and Cross

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

jpenuliar
Valued Contributor III

Re: Transpose and Cross

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...

Community Browser