topic Re: Problems to export to Excel format currency in QlikView

Problems to export to Excel format currency

Mon, 11 Feb 2013 19:22:02 GMT

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

vadimtsushko — Mon, 03 Feb 2014 13:38:34 GMT

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

Wed, 05 Feb 2014 21:38:32 GMT

Thanks Vadim Tsushko

Wed, 12 Nov 2014 12:10:41 GMT

Hello Marcos,

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

Thanks!

Anonymous — Fri, 04 Aug 2017 15:57:52 GMT

HI,

Is the functionality there inb Qlik Sense?