Load yor sample data in the Sample work book using crosstable load and you willsolve your problem.
A sample qvw is attached for your reference
test0113c.qvw 148.8 K
I thank you for quick and excellent answer... It solved... But I have a Huge Data Base.. I want to learn :
What is the mean of 4 : I think it is "take product and data values" from 4th line from LOAD sentence...
Can you tell me the right please..
CrossTable(Product, Data, 4)
LOAD [Member Code],
(ooxml, embedded labels, table is Sample);
The first four columns of the Excel spreadsheet ([Member Code],Name,COUNTRY,[DATE(dd:mm:yyyy)]) are loaded as fields in the target table. For the remaing columns, the top row is loaded as the field Product and the data below these columns are loaded as the next field.
This is the standard method of loading crosstable data. You may refer the Qlikview reference manual for further details.