Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner

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!

farisahamad
Creator
Creator

HI,

Is the functionality there inb Qlik Sense?