topic Re: Export a QlikView Ajax Doc to excel programmatically in QlikView

Export a QlikView Ajax Doc to excel programmatically

justindelisi — Sat, 16 Nov 2024 19:14:00 GMT

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.

Re: Export a QlikView Ajax Doc to excel programmatically

Nicole-Smith — Fri, 24 Jan 2020 21:47:48 GMT

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.

Re: Export a QlikView Ajax Doc to excel programmatically

Brett_Bleess — Thu, 20 Feb 2020 19:21:04 GMT

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/mashups-start.htm

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

Re: Export a QlikView Ajax Doc to excel programmatically

MikeW — Tue, 10 Mar 2020 04:32:40 GMT

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/ta-p/1682616

Re: Export a QlikView Ajax Doc to excel programmatically

erikzions — Fri, 11 Dec 2020 22:50:02 GMT

I have this exact need. I am exporting a small table to a text file for use elsewhere. The Export Action works fine in IE. It doesn't work in AJAX and they don't want to limit people to IE since it isn't their preference. (mumble grumble grumble) have you had any luck?

Re: Export a QlikView Ajax Doc to excel programmatically

justindelisi — Sat, 12 Dec 2020 00:01:26 GMT

No unfortunately I haven't. I ended up making a qlik app that exported the
qvd I needed to a csv and then picked it up with a cloud ETL service to use
it elsewhere.