Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to Excel - Issue

Hi,

I am trying to export a chart with a column with different number formats. In the chart the numbers look great but when I press "Send to Excel" or right click the chart and choose the "Send to Excel" option, the exportation process converts every value in a String format with the mask I have set ('$ #,##0', '#,##0' , '#.## %', etc ) and what I wanted is to keep those formats.

The only solution I have found by now, is to "ctrl+c" the chart then paste it into an excel document, but this is too tricky for a end-user.

I am QlikView 11.20 SR5 (64 bit)

Any suggestions?

Thanks for your time.

Mensaje editado por: Ryuma Nakano

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You could try using a macro: Number format is lost when exporting to excel


talk is cheap, supply exceeds demand