topic Qlikview Bad Zip File? in QlikView

Qlikview Bad Zip File?

Mon, 31 Jan 2011 22:46:41 GMT

This part of the code gives me the error which is baffling me, can anyone help me with this?:

LOAD Target,
Actual as CP_Actual,
Month as CP_Month
FROM [\\navy\data\QUALITY\CAR\LOG\2010 CAR log.xls]
(ooxml, embedded labels, table is [DWO Corrective Preventive Actio], filters(
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Col, Pos(Top, 14)),
Remove(Col, Pos(Top, 14)),
Rotate(right)
));

the error it gives me is-

Bad Zip File
LOAD Target,
Actual as CP_Actual,
Month as CP_Month
FROM [\\navy\data\QUALITY\CAR\LOG\2010 CAR log.xls]
(ooxml, embedded labels, table is [DWO Corrective Preventive Actio], filters(
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Col, Pos(Top, 14)),
Remove(Col, Pos(Top, 14)),
Rotate(right)
))

and then it shows 'Sheet properties' with available fields(which i think is normal) and then it also opens up the 'Edit Module' window.

I am very new to qlkview, so I am sorry if it sound like I dont know anything, because I kinda dont.

Also there is actually no zip file involved

Thanks,

Raj

Qlikview Bad Zip File?

Fri, 10 Jun 2011 08:41:57 GMT

Hi - I've just had this too.

The spreadhseet that Qlikview was loading from crashed yesterday and although the user was able to recover the excel spreadsheet and excel seemed fine, Qlikview didn't seem to like it. I tried renaming the spreadhseet etc to no avail but I copied the worksheets one by one to a new spreadsheet and saved it under the same name as the old one and Qlikview seems happy.

Not a very neat solution but it works!

Re: Qlikview Bad Zip File?

dgy — Wed, 11 Jul 2012 15:49:05 GMT

I had the same problem, it was caused by the spreadsheet being password-protected.