Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

specify delimiter when exporting chart to csv?

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

Labels (1)
5 Replies
balrajahlawat
Esteemed Contributor

Re: specify delimiter when exporting chart to csv?

qlikviewnovice
Valued Contributor II

Re: specify delimiter when exporting chart to csv?

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
Valued Contributor II

Re: specify delimiter when exporting chart to csv?

Hi,

in script just do

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

HTH

André Gomes

Not applicable

Re: specify delimiter when exporting chart to csv?

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
Valued Contributor II

Re: specify delimiter when exporting chart to csv?

OK