topic Re: Qliksense November 2017 - Excel as data source in App Development

Qliksense November 2017 - Excel as data source

reshma_km — Thu, 22 Feb 2018 18:18:03 GMT

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?

Re: Qliksense November 2017 - Excel as data source

Ivan_Bozov — Thu, 22 Feb 2018 21:56:35 GMT

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.

Re: Qliksense November 2017 - Excel as data source

reshma_km — Thu, 22 Feb 2018 21:59:33 GMT

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

Re: Qliksense November 2017 - Excel as data source

Ivan_Bozov — Thu, 22 Feb 2018 22:03:26 GMT

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

Re: Qliksense November 2017 - Excel as data source

reshma_km — Thu, 22 Feb 2018 22:16:29 GMT

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.“

Re: Qliksense November 2017 - Excel as data source

Ivan_Bozov — Thu, 22 Feb 2018 22:19:08 GMT

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

Re: Qliksense November 2017 - Excel as data source

reshma_km — Thu, 22 Feb 2018 22:26:08 GMT

Ok.

Re: Qliksense November 2017 - Excel as data source

Ivan_Bozov — Sun, 25 Feb 2018 09:45:53 GMT

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