Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Converting Expression Values into currency standard

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.

9 Replies
Highlighted
Contributor II

Re: Converting Expression Values into currency standard

Hi

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

Regards

Tripati

Highlighted
Luminary
Luminary

Re: Converting Expression Values into currency standard

Hi Bhargav:

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

Best Regards,

Juan P. Barroso

Highlighted
New Contributor III

Re: Converting Expression Values into currency standard

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.

Highlighted
New Contributor III

Re: Converting Expression Values into currency standard

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.

Regards,

Bhargav

Highlighted

Re: Converting Expression Values into currency standard

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

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Converting Expression Values into currency standard

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
New Contributor III

Re: Converting Expression Values into currency standard

Capture.JPG

Highlighted
Partner
Partner

Re: Converting Expression Values into currency standard

Hi


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

Highlighted
Honored Contributor III

Re: Converting Expression Values into currency standard

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])