Discussion Board for collaboration on QlikView Scripting.
not clear, what you wish to achieve,
can you also post the desired result?
Hi i am aching a sample with my data and result which i need....
You need output as below only two rows?
with other filters
Can you upload sample QVW
Is it something like (with offset)
Data AS R1, // or [Class A]
Data1 AS R2, // or [Class B]
Data2 AS R3,
Data3 AS R4,
Data4 AS R5,
Data5 AS R6
(ooxml, embedded labels, header is 3 lines, table is Sheet1);
Or do you need to have the data normalized (CROSSTABLE)?
yes i need it normalised....
CROSSTABLE (Class, Data, 4) LOAD Metel,
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...