Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

reshma_km
Contributor III

Qliksense November 2017 - Excel as data source

Hi,

There is a proposed app which uses excel files as data source. The excel files are very large in size. Is this recommended? Can we support and maintain it in server without issues in future?

Is there any limit to the data volume when we use excel as source?

1 Solution

Accepted Solutions
Ivan_Bozov
Valued Contributor

Re: Qliksense November 2017 - Excel as data source

This is when you attach the file to the app. If you have a normal connection to the data this limitation does not apply.

7 Replies
Ivan_Bozov
Valued Contributor

Re: Qliksense November 2017 - Excel as data source

Hi! Loading large Excel files should not be an issue for Qlik Sense. I have used some Excel files larger than 300MB without any problems. However, this has negative impact on the load time and I would recommend that you store the data as QVD files (especially useful if you have historical data that does not change) and use them as source.

reshma_km
Contributor III

Re: Qliksense November 2017 - Excel as data source

Thanks. So I guess you loaded the excels through data load editor (script) and not data manager (drag and drop), correct?

Ivan_Bozov
Valued Contributor

Re: Qliksense November 2017 - Excel as data source

I used the script, but both ways should be possible.

reshma_km
Contributor III

Re: Qliksense November 2017 - Excel as data source

In Qlik help, I read that The maximum total size of files attached to the app, including image files uploaded to the media library, is 200 MB.“

Ivan_Bozov
Valued Contributor

Re: Qliksense November 2017 - Excel as data source

This is when you attach the file to the app. If you have a normal connection to the data this limitation does not apply.

reshma_km
Contributor III

Re: Qliksense November 2017 - Excel as data source

Ok.

Ivan_Bozov
Valued Contributor

Re: Qliksense November 2017 - Excel as data source

If your question is answered, please mark it as such to close the topic.