specify delimiter when exporting chart to csv?

[#1]

Hi,

We have published some pivot tables and straight table charts to web. Whenever the users want to export the charts to csv, the delimiter used is comma. The users have also some string fields that contain comma as a value.

Is it possible to change the delimiter while exporting the chart to CSV. If yes, please explain how to do it

P.S: One way to do it is using a macro but I would like to avoid that because we have a lot of charts and few charts are dynamically generated using a a dynamic dimension selector where the user can choose which fields he wants to see in the chart

Regards

Shah

[Anonymous]

did you check this?

How to Customize the Separator Character When Exporting QlikView Objects to CSV Files

[Anonymous]

Hi,

Right click the table, choose the Export option from the context menu and select as Save as Type the option Semicolon delimited (*.skv, *.txt) or which ever format you would like to save

The Export action can only export to comma separated values. There are no options to change the delimiter. If you still want to export using a button you'll have to write macro code to do that.

Hope it helps!!

[agomes1971]

Hi,

in script just do

Store <Table> into Filename.csv (txt) ;

HTH

André Gomes

[#5]

Hello,

We are not storing the table in the loading script. We want to export a chart that is a combination of different tables

[agomes1971]

OK