Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
priyarane
Valued Contributor

Export to Excel

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Export to Excel

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

View solution in original post

4 Replies
Highlighted
Not applicable

Re: Export to Excel

Highlighted
Partner
Partner

Re: Export to Excel

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

View solution in original post

Highlighted
Partner
Partner

Re: Export to Excel

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.

Highlighted
priyarane
Valued Contributor

Re: Export to Excel

Users are exporting from Table box