Excel Reports

[Kayleigh_Milewski]

The new reporting service only appears to allow for export to PDF. Is it possible to automate reporting on tables to Excel formats or will this be a feature coming in the near future?

[anat]

In the load script of your application you can have at the end STORE-statements that can store an in-memory table in a text (CSV)-file or a QVD-file. This in-memory table will not necessarily be like tables you create in the UI. That depends on what kind of calculations you do in your Qlik charts. For normal purposes you could do calculations and aggregations in the tables in the load script so you will get the desired results in the in-memory tables that you want to store in text or QVD-files.

STORE <table-name> INTO <a-file-name>.txt (txt);

STORE <table-name> INTO <another-file-name>.qvd (QVD);

The best solution would probably be to use Qlik NPrinting where you can store charts and data directly from Qlik applications not only in-memory tables to various Microsoft Office formats including of course Excel.

[Andrew_Kruger · Accepted solution]

Hi Kayleigh, thank you for the post. Support for composition of tabular format report templates and bursting those is  a future roadmap item for sure!  

To add to the alternate approach by @anat, for a simple table export use case you could experiment with Automation and the O365 Excel connector / Google Sheet connector to dynamically write simple table based outputs to spreadsheets.  Using the looping technics and the connector you could write to different sheets dynamically as well.