topic Re: excel is not loading in QlikView

excel is not loading

Tue, 03 Dec 2013 11:56:48 GMT

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

Re: excel is not loading

matthias_v — Tue, 03 Dec 2013 12:08:43 GMT

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.

Re: excel is not loading

MK_QSL — Tue, 03 Dec 2013 12:12:47 GMT

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';

Re: excel is not loading

Tue, 03 Dec 2013 12:18:37 GMT

thank for u r reply but

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

plz sir

Re: excel is not loading

MK_QSL — Tue, 03 Dec 2013 12:19:32 GMT

please check enclosed file...

Re: excel is not loading

Tue, 03 Dec 2013 13:53:50 GMT

can u attach in script format

plz

Re: Re: excel is not loading

matthias_v — Tue, 03 Dec 2013 14:11:47 GMT

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

Re: Re: excel is not loading

Tue, 03 Dec 2013 14:40:21 GMT

thank u so much for u r time.

i tired but circular loop and syn keys are coming.

Re: Re: excel is not loading

matthias_v — Wed, 04 Dec 2013 14:07:29 GMT

Could you post the code that you have so far.