Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Export a QlikView Ajax Doc to excel programmatically

We have several QlikView web apps and I'm trying to pull some data from these apps to be used on a web app dashboard. The only access to the qlik apps I have is through the ajax versions. I know that I can right click on tables and export to excel but is there a way anyone knows of to do this with an external script in javascript or python perhaps? I know there are APIs for QlikSense apps to export data from mashups but I couldn't find anything for QlikView. 

Labels (5)
3 Replies
Highlighted

Re: Export a QlikView Ajax Doc to excel programmatically

There are some items that allow you to do document/object integration in other applications:
https://community.qlik.com/t5/QlikView-Documents/QlikView-MashUp-Documentation-Examples/ta-p/1481500

If the above doesn't solve for what you're trying to do, your best bet would be to have the developer of the application export the data to a .txt file (using the Qlik View load script) that you can then read into your application.

Highlighted
Digital Support
Digital Support

Re: Export a QlikView Ajax Doc to excel programmatically

Just adding a link to the Help regarding Mash-ups in QlikView that Nicole mentioned in her post.

https://help.qlik.com/en-US/qlikview-developer/April2019/Subsystems/Mashups/Content/QV_Mashups/mashu...

To Nicole's other point, really need further information on the use case you are attempting to solve in order to determine if there may be other ways to do things.  One other that came to mind would be to create QVD files in the app from which you are trying to get the data such that you can use those QVD files in the other apps rather than trying to export/import etc.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Contributor

Re: Export a QlikView Ajax Doc to excel programmatically

I have posted some sample javascript code that exports pivot or straight table chart to csv. You can probably modify it to do what you need.

https://community.qlik.com/t5/QlikView-Documents/Useful-Qlikview-Javascript-for-Chrome-Ajax-client/t...