topic Problem while loading Date from Excel in QlikView

Problem while loading Date from Excel

Tue, 09 Feb 2010 13:50:07 GMT

Hi,

I'm new to Qlikview so this may be a really stupid question.

I'm trying to load a date from an Excel file (Excel 2007, xlsx format). I'm attaching the Excel file.

If i do this:


LOAD * FROM

(ooxml, embedded labels, table is Hoja1, filters(
Remove(Row, Pos(Top, 3))
));

Qlikview shows 40217.000000 but when I do this:


LOAD * FROM

(ooxml, embedded labels, table is Hoja1);

I get the actual date that I'm looking to load (in addition to the lala text of course).

Can anyone tell me what am I doing wrong?

Thanks!

Problem while loading Date from Excel

Tue, 09 Feb 2010 13:51:59 GMT

Hi,

what are you trying to achieve? Only to import cells with a valid date in it?

Best regards

Stefan

Problem while loading Date from Excel

Tue, 09 Feb 2010 13:57:31 GMT

I'm trying to load an Excel that is a little bit more complex that the one I posted, but the problem I'm having reduces to the example above.

In this particular case, I'm trying to do exactly that: import a cell with a valid date.

Thanks for your help!

Problem while loading Date from Excel

Thu, 11 Feb 2010 09:58:09 GMT

Hi,

try to do the following:

LOAD
Date
FROM
C:\Users\stefan.walther_local\Desktop\excel_file.xlsx
(ooxml, embedded labels, table is Hoja1)
WHERE IsNum(Date)
;

Best regards

Stefabn

Problem while loading Date from Excel

Thu, 11 Feb 2010 13:10:56 GMT

Thanks for your answer Stefan.

Even though that solves the problem in this case, it does not work in general. Suppose instead of 'lalala' I have another date in the excel file, but only want to load the first one. In that case your script would load both dates and mine should only load the first one (in reality, it only loads the first one but with the wrong format).

Any other ideas? I think this might be a bug...

Problem while loading Date from Excel

Fri, 12 Feb 2010 09:32:24 GMT


mchicote wrote:
Thanks for your answer Stefan.
Even though that solves the problem in this case, it does not work in general. Suppose instead of 'lalala' I have another date in the excel file, but only want to load the first one. In that case your script would load both dates and mine should only load the first one (in reality, it only loads the first one but with the wrong format).
Any other ideas? I think this might be a bug... <div></div>

OK, loading just the first one?

What's about using FIRST:

First 1
LOAD Date
FROM
C:\excel_file.xlsx
(ooxml, embedded labels, table is Hoja1);

Best regards
Stefan

Problem while loading Date from Excel

Tue, 16 Feb 2010 17:39:53 GMT

Stefan,

Thanks for your answer. However that only solves the problem partially. If I want to load two dates, that won't work.

The only way I could make this work was to load the entire excel and then delete the unwanted rows manually (with another LOAD and a WHERE clause) .

Bottom line, I think filters while loading from Excel don't work.