Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
help4qv123
Creator II
Creator II

T

hi

10 Replies
prieper
Master II
Master II

not clear, what you wish to achieve,

can you also post the desired result?

Peter

help4qv123
Creator II
Creator II
Author

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

prma7799
Master III
Master III

You need output as below only two rows?

 

ClassABCDEF
Sum(data)36918005115118011141200
help4qv123
Creator II
Creator II
Author

with other filters

Anonymous
Not applicable

Can you upload sample QVW

prieper
Master II
Master II

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
Creator II
Creator II
Author

yes i need it normalised....

prieper
Master II
Master II

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
Partner - Specialist III
Partner - Specialist III

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