topic Re: Export to Excel in QlikView

Export to Excel

priyarane — Thu, 02 Apr 2015 12:28:40 GMT

Hi Experts,

How many columns and rows can be exported from QV to Excel.

In my scenario, I have >300 columns in Table box and users are reporting that not able to see all the columns and many issues.

If any limitations in QV then how can we over come that issue?

Thank you,

Priya

Re: Export to Excel

Thu, 02 Apr 2015 12:37:28 GMT

Check this Limit to the number of rows that a user can export to excel

Mohssine AMHACHI

Re: Export to Excel

stigchel — Thu, 02 Apr 2015 12:49:14 GMT

The number of rows and columns qv can export mainly depends on the excel version you are using. In older excel versions the nr of columns is limited to 256. You can maybe use a csv export instead?

Also see

Re: Limitation of data to download as excel

Re: Export to Excel

praveenak — Thu, 02 Apr 2015 12:56:37 GMT

Hi,

I don't think there is a limitation on the no.of rows/columns to be exported to excel.

Any no.of rows/columns can be exported. But the no.of columns visible is only based on the excel version you use(like excel 2003 is limited to 256 columns).

In your case, the problem may be due to any aggregations on the fields,in the script. Please verify that.

Or if you can provide the QVW file, we can find the problem.

Re: Export to Excel

priyarane — Thu, 02 Apr 2015 13:44:17 GMT

Users are exporting from Table box