Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems to export to Excel format currency

  Dear QVCommunity

I have a pivot table in which I have an expression in which we assign the currency format by Selected.

Money (Sum (Sales), $ (vCurrency))

The variable value is vCurrency

If(Moneda='COP','$ #.##0;($ #.##0)','USD #.##0,00;(USD #.##0,00)')

The number format tab Expression Number is marked by default, when I export to Excel the values ​​are output as text in Excel.

If you change the number format in the Number tab by currency works correctly, the problem is that he could not differentiate between USD and $

In a post to review said it was for issues QV 11 SR version, migrate both server and desktop QV11 SR2 and this did not solve the problem

http://community.qlik.com/message/205011#205011

4 Replies
vadimtsushko
Partner - Creator III
Partner - Creator III

I believe that functionality works now.

We've switched to such technic in current projects. Tested with QV11 SR4 and SR5

Take a note that currently Num() formatting does not preserve by `Sent to Excel` command, but Money() formatting exports correctly

Not applicable
Author

Thanks Vadim Tsushko

Not applicable
Author

Hello Marcos,

I have the same problem like you. Did you find any solution?

Thanks!

Anonymous
Not applicable
Author

HI,

Is the functionality there inb Qlik Sense?