topic Re: Data Export in QlikView

Data Export

polisetti — Fri, 07 Mar 2014 13:31:12 GMT

Hi,

Can we change the format of the data exported in excel, so that it is easier to convert to charts.

Please guide me..

Re: Data Export

sudeepkm — Fri, 07 Mar 2014 13:42:24 GMT

As per my knowledge I think The export to excel exports only data. to export visualization you may use.

1. a macro or

2. print object feature or

3. copy to clipboard and paste at the destination

Kindly let me know if your query was different

Re: Data Export

alexandros17 — Fri, 07 Mar 2014 13:45:19 GMT

When you export to excel (directly from qlik, without any tool I mean) you cannot decide the format, probably you could with a macro but it is better not to use macro because macros will be no more supported in the future

Hope it helps

Re: Data Export

jagan — Fri, 07 Mar 2014 13:49:14 GMT

Hi,

Before exporting give proper formatting in Format tab of charts, so that the data format is exported correctly like date, integer, Floating numbers etc. If you didn't specify the format then when exporting the data results in unexpected results.

Regards,

Jagan.