topic Re: Export and Save .csv through Access Point in QlikView

Export and Save .csv through Access Point

jrl — Mon, 10 Feb 2020 16:26:09 GMT

Is it possible to use the Export action item to save a .csv file? I'm working through the Access Point so macros are not an option. I have built a button that uses the 'Export' function and it can create the .csv, but it only seems to open it in another window as opposed to saving it to the desired location. Any thoughts?

Re: Export and Save .csv through Access Point

rwunderlich — Tue, 11 Feb 2020 01:11:54 GMT

When using the server with browser, you can use the ServerSideExport API call in a macro to do the trick.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Export and Save .csv through Access Point

jrl — Tue, 11 Feb 2020 01:34:04 GMT

Unfortunately macros are not an option because we're using an AJAX plug-in

Re: Export and Save .csv through Access Point

rwunderlich — Tue, 11 Feb 2020 15:02:16 GMT

You can still use macros with Ajax, you just have to make sure to use the correct API calls. Hence the ServerSIdeExport recommendation. You'll need to use API calls that run on the server, not the client.

-Rob

Re: Export and Save .csv through Access Point

Brett_Bleess — Thu, 05 Mar 2020 20:25:55 GMT

Just wanted to provide the API Guide for QlikView to you in case you decided to check out the API Rob mentioned.

QlikView API Guide QVW

I am not quite sure what is not working for you regarding the Export action, which is what I think you are using, here is help link on that:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Button2.htm#anchor-4

Click the Add Action Dialog link on the right side to jump down to the Actions area and scroll down until you see Export. Sorry for the confusion on my part.

Regards,
Brett

Re: Export and Save .csv through Access Point

Larry_blacc — Thu, 18 Jan 2024 11:50:34 GMT

Hello,

Please I have thesame issues. I have the Qlikview client side access.
Using API requests, I am able to login and load the report but I don't know how to export the report as csv.

Can someone help with this, please? Maybe point me in the direction of the API document to achieve this, again it is from the client side.

Thank you.