topic Re: Converting Expression Values into currency standard in QlikView

Converting Expression Values into currency standard

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a value $1,211,325,588.00 as the currency value in the along with other columns in the table. But i am not able to format it to standard currency representation with Thousands, Millions or Billion separators. They are graded out. Could any one help me on this formatting?

Thanks in advance.

Re: Converting Expression Values into currency standard

tripatirao — Wed, 18 Apr 2018 07:30:40 GMT

Share your current currency vale, how it is looking and how you want to display.

Regards

Tripati

Re: Converting Expression Values into currency standard

jubarrosor — Wed, 18 Apr 2018 07:34:04 GMT

Hi Bhargav:

Are you try to modify de format mask of the expresion?

Best Regards,

Juan P. Barroso

Re: Converting Expression Values into currency standard

Anonymous — Wed, 18 Apr 2018 08:47:53 GMT

Hi Sir,

Currently the value is $1,211,325,588.00. I want to make it as 1.2 Billion is such formats. I have many such columns in the table to convert to. I tries the properties -> Number and format there. The options are grayed out.

I am working in Qlikview Desktop.

Re: Converting Expression Values into currency standard

Anonymous — Wed, 18 Apr 2018 08:48:09 GMT

Hi Sir,

I am working in Qlikview Desktop.

Regards,

Bhargav

Re: Converting Expression Values into currency standard

PrashantSangle — Wed, 18 Apr 2018 09:02:14 GMT

did you select override Document setting in number property???

can you share screen shot of it.

also you can use num(numberField/10000000,'#.##')& ' Billion'

Regards

Re: Converting Expression Values into currency standard

Anil_Babu_Samineni — Wed, 18 Apr 2018 09:02:41 GMT

Perhaps this?

=Num(Round(Measure/1E9, 0.1),'## Billion')

Re: Converting Expression Values into currency standard

Anonymous — Wed, 18 Apr 2018 09:10:45 GMT

Re: Converting Expression Values into currency standard

Anonymous — Wed, 18 Apr 2018 11:47:18 GMT

num(numberField/1000000000,'##.#0 Billion')

Re: Converting Expression Values into currency standard

sasiparupudi1 — Wed, 18 Apr 2018 12:23:27 GMT

You have to do this in the script. may be using a dual something like this

Dual(Num(Round(1211325588.00 /1000000000,0.1),'## Billion'),[number field])