topic Format as currency in QlikView

Format as currency

Mon, 25 Apr 2011 13:11:05 GMT

Dears,

How can I format a text object value as Currency (in USD)?

The problem is that today the value is presented like: 123456789.00 (coz I created a formula to create the decimal value). And I would like to present the value like: USD 123,456,789.00

How can I do it?

Thanks for your attention

Best regards

Format as currency

ashfaq_haseeb — Mon, 25 Apr 2011 13:16:33 GMT

Hi kelly.

In your text box just try the following code to append usd as first.

='USD '&

sum(Sales)

Hope that helps

Regards

ASHFAQ

Format as currency

erichshiino — Mon, 25 Apr 2011 13:25:50 GMT

Hi,

If you use num fuction it will be only a mask for you numbers. There is no difference for text objects, but you could use the exactly same expression on a chart and it would be recognized as a number when you export it to excel (instead of a string).

try:

=NUM( sum(value),'USD #,##0.00', '.',','),

where sum(value) can be replaced by any of your expressions.

Format as currency

Mon, 25 Apr 2011 13:31:16 GMT

Thanks Erich.

It really solved my problem!

Format as currency

Mon, 25 Apr 2011 13:31:54 GMT

Hi,

If I understood your problem here is the solution.Let me know the query if any...

'USD'&NUM((USD),'###,###,###.##')

Thanks & Regards

Jai