topic Excel in Compatibility Mode? in QlikView

Excel in Compatibility Mode?

Mon, 14 Dec 2015 19:23:32 GMT

Hi community,

I have to load an excel file which is in compatibility mode to qlik. When I am trying to load it into qlik it is loading only 250 records out of 12000 records. How to resolve this, without making any changes in excel, I need to do it in qlik itself. Any solution?

Re: Excel in Compatibility Mode?

tamilarasu — Tue, 15 Dec 2015 02:06:41 GMT

I have tested sample data in my system and working fine for me. Could you post your excel. ?

Re: Excel in Compatibility Mode?

HirisH_V7 — Tue, 15 Dec 2015 04:31:57 GMT

Hi ,

Please, post Sample Data .

-Hirish

Re: Excel in Compatibility Mode?

jonathandienst — Tue, 15 Dec 2015 04:43:52 GMT

An Excel file cannot be in "compatability mode" -- that applies to the appearance in the Excel application and has no affect on the file. Is there a completely blank line in the file? You may need to use the Qlikview filter functions to skip the empty line. Start the table file wizard by clicking on Table Files in the script editor. Click on the button "Enable Transformation Step" in the second page of the wizard. Click Conditional Delete..., and use Column 1 is empty as the skip condition. Click Add and OK and verify how many rows you have. Click Next and Finish. This will add the filter to the qualifier part of the From statement - eg:

FROM C:\Qlikview\Test\Book1.xlsx

(ooxml, no labels, table is Sheet1, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

));

Re: Excel in Compatibility Mode?

Tue, 15 Dec 2015 11:20:51 GMT

Hi Jonathan

Thanks for the reply.

I don't have any blank lines in the sheet. It's just in comapatibility mode. I have to load it into qlik. But it is not loading. Any other solution?