Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Export to excel with function

Hi,

I have done one table in Qlikview and I want to export it. However I can not export the entire table to the excel (just the value). I created one function which originates arrows based on the VALUE1, but this arrows are not exported to excel. How can I overcome this problem?

4 Replies
MVP
MVP

Re: Export to excel with function

Hi

AFAIK there is no way to export the arrows into Excel as a table - the only option is to export a bitmap image of the object.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Export to excel with function

The problem is that the table is big and if you export as a bitmap it only contains part of the all the information. The image is equal to the window of the qlikview page and you cant scroll down to see the others rows since it is an image.

Do you have any suggestions?

consenit
Contributor II

Re: Export to excel with function

Hi Pedro.

Have you tried doing the export to bitmap in a macro? I believe the QlikView API is far more powerful than the default menus, after all, it's what utilities like NPrinting are based on.

Kind regards,

Ernesto.

NickHoff
Valued Contributor

Re: Export to excel with function

You can solve your problem by using the report generator and adding a print report button with the report id linked.  Just click Reports > Edit Reports, add a new report and drag and drop the items you'd like to add to the report including the arrows..  You can create a custom header as well, and include your current selections in the report.

Edit:  You'll want to add the multi page option if your report is large.