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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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