Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

faheem_momin
New Contributor

cannot export more than 1 million cells data in qlik sense

We have created report for account and when we try to export into excel, it is fetching only 1millions cells data into excel.


Is there any limitation in Qlik sense for exporting the data into Excel?

Please help.

1 Solution

Accepted Solutions
martinpohl
Valued Contributor II

Re: cannot export more than 1 million cells data in qlik sense

it is not the limitation of sense, it is the limitation of excel.

who needs more than 1 million records in details?

3 Replies
martinpohl
Valued Contributor II

Re: cannot export more than 1 million cells data in qlik sense

it is not the limitation of sense, it is the limitation of excel.

who needs more than 1 million records in details?

thornofcrowns
Valued Contributor II

Re: cannot export more than 1 million cells data in qlik sense

If you have more than a million rows, Excel isn't the way to go, at least not just dumping the whole lot onto one sheet.

mauricewehbe
Contributor

Re: cannot export more than 1 million cells data in qlik sense

Hi Faheem,

See Microsoft limitations for excel:

ScreenShot001.png