topic Re: Different data when I load .csv and .xls file in QlikView

Different data when I load .csv and .xls file

Thu, 28 May 2015 14:36:08 GMT

Hello,

I have an issue when I try to load some data.

First, from a bigger qlikview application I export a table to .xls and .csv both. (So, I have 2 files theoretically with the same data)

When I load both file into a new qlikview application to check the data. In the table where I loaded the data from .xls, are fewer fields, and the sum of the numbers is smaller than .csv .

I've tried to export to .xls and .csv with different Number format from qv, Fixed to , Integer, Number, Default. And the result is the same.

Can you give me an idea how to fix this ?

Thanks,

Claudiu

Re: Different data when I load .csv and .xls file

Agis-Kalogiannis — Thu, 28 May 2015 18:52:57 GMT

What is the amount of data you are exporting?

It might have to do with .xls format limitations.

Don't forget that you cannot have more that 1 million rows on a single worksheet, and this, in the newer versions of Excel.

Can you please check this out?

Thanks

Agis

Re: Different data when I load .csv and .xls file

Fri, 29 May 2015 06:07:48 GMT

Hi,

Thank you for your answer.

I've checked the amount of data. See the picture. I did a sum and COUNT for the fields, and it's not reaching 1 million.

Re: Different data when I load .csv and .xls file

jonathandienst — Fri, 29 May 2015 06:12:06 GMT

As the previous poster suggested, you have reached the maximum number of rows for an .xls file (65534). 1 million rows is the limit for .xlsx format files. The CSV does not have this limit.

Depending on how you exported to Excel, the other ~12000 rows may be in a separate tab on the XLS file.

Re: Different data when I load .csv and .xls file

Fri, 29 May 2015 06:13:57 GMT

Can you tell how should I export to Excel in order to be ok ?

Re: Different data when I load .csv and .xls file

jonathandienst — Fri, 29 May 2015 06:15:31 GMT

Qlikview does not directly support exporting to xlsx format or more than 64k rows to xls fornat. For more than that number of rows, csv might be your best bet.

Re: Different data when I load .csv and .xls file

Fri, 29 May 2015 06:18:52 GMT

Ok. Thanks a lot for this information. I will keep working with csv on this case.