excel is not loading

[#1]

Hi experts,

I am practicing exercise in qlikview.

in excel there is file called summary report.in this excel file year(2004,2005,2006,...2011) field is there.while loading the excel file through table file only 2010 is loading .please anyone help me ?

i am attaching the excel below

[matthias_v]

Hello,

In attachment you will find two possible solutions to your problem.

The problem was that QlikView sees every sheet in your excel document as a table. So you have to read every table in the document.

Enjoy.

[MK_QSL]

use below....Try to change .xls to .xlsx

For Each vSheet in '2010','2009','2008','2007','2006','2005'

CrossTable(TYPE, Data, 2)

LOAD Year,

     DivisionName,

     //CategoryName,

     [Baby Clothes],

     [Children's Clothes],

     [Men's Clothes],

     [Men's Footwear],

     Sportswear,

     Swimwear,

     [Women's Clothes],

     [Women's Footwear]

FROM

(ooxml, embedded labels, table is $(vSheet))

Where DivisionName <> 'Total';

NEXT

[#4]

thank for u r reply but

i cant understand how to do ?can u expand the details

plz sir

[MK_QSL]

please check enclosed file...

[#6]

can u attach in script format

plz

[matthias_v]

Guess not all of us own a license

Script:

FOR i = 2005 TO 2010

//AUTOMATIC CONCATENATION WILL HAPPEN BECAUSE THE TABLES ARE THE SAME

//CONCATENATION = PASTING THE TABLES TOGETHER

DATA:

LOAD

  Year,

     DivisionName,

     CategoryName,

     [Baby Clothes],

     [Children's Clothes],

     [Men's Clothes],

     [Men's Footwear],

     Sportswear,

     Swimwear,

     [Women's Clothes],

     [Women's Footwear]

FROM

SummaryReport.xls

(biff, embedded labels, table is [$(i)$])

Where Year <> 'Total';

NEXT

PS: Make sure the excel is in the same folder as your .QVW

[#8]

thank u so much for u r time.

i tired but circular loop and syn keys are coming.

[matthias_v]

Could you post the code that you have so far.