Problem while loading Date from Excel

[#1]

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!

[#2]

Hi,

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

Best regards

Stefan

[#3]

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!

[#4]

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

[#5]

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...

[#6]

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

[#7]

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.