Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Bad Zip File?

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

2 Replies
Not applicable
Author

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!

dgy
Employee
Employee

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