Export CSV file via AJAX client

[googel84]

Hi there, is there a way to automate the Export... function which is available through the following contextual menu of a chart in an application published through the Access Point?

In other words, is possibile to set up a button which does the same as the Export... command?

Thnaks

[jerrysvensson]

You can do a ServerSideExport using a macro. Although that file will end up on the server.

Have a look in the APIguide (search the forum for it)

[googel84]

Hi, thanks for the quick reply.

I have already tried that but it seemed not to be working once put on the access point.

In addition, the ideal result would be to automatically download the file, instead of putting it in a shared drive.

Thanks anyway.

[Peter_Cammaert]

You can use the Excel icon in the caption of your chart/table.

Exports to HTML, not CSV. But to Excel that's almost the same.

Peter

[googel84]

Actually I shoudl have cleared it at the beginning.

The problem is the number of columns to export: when you export to Excel, there is a limit of 256 (or so); when you export to csv, there is no limit (or, at least it is much higher then 256).

Thanks anyway.

[jerrysvensson]

It should work, I use it myself.

Put the file on a local path on your QlikView server to test.

[bindu_apte]

Hi,

I am using one application where I used to click on button and it will export to excel.

If you are using Ajax then you need to install IE plugin. Through IE it will work fine.

[googel84]

Thanks, but the IE plugin is not an option for us and  I guess the limit on the number of columns you can export would be still there.

Thanks anyway.

[ashokamp]

Hi Alberto,

Do you got the solution?CSV export using a button. Kindly let me know the solution. I have a same scenario here.

Thanks

Ashok

[googel84]

Unfortunaterly no... The client accepted the "Right-click-and-Export"solution and we did not go any further.