Discussion Board for collaboration related to QlikView App Development.
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
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
Thanks Vadim Tsushko
I have the same problem like you. Did you find any solution?
Is the functionality there inb Qlik Sense?