Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting a dimension field to currency format($#.##)

Hi,

I have a chart that thas a price field that I want to format so that its in a currency format i.e. 26 to read $26.00. The field a dimension as opposed to expressions.

Does anyone know how I can format this dimension field so that it appears in currency format? I tried to use the money# function like this

money#(Price, '$#' , '.' , ',') but it doesn't work. I'm trying to apply the money# function in the chart. Do I have to do this in the load statement instead?

thanks,

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello Mike,

It should work in both script and expression editor.

If the field is actually a number or a numeric value, then you just need to

Money(Field)


This will take by default, without any modifier, the value of the variable "MoneyFormat" that is at the top of your main tab in the script editor.

Hope that helps.

View solution in original post

3 Replies
Miguel_Angel_Baeyens

Hello Mike,

It should work in both script and expression editor.

If the field is actually a number or a numeric value, then you just need to

Money(Field)


This will take by default, without any modifier, the value of the variable "MoneyFormat" that is at the top of your main tab in the script editor.

Hope that helps.

View solution in original post

Not applicable
Author

Thanks so much. So easy once you pointed that out. Much appreciated.

mov
Champion III
Champion III

It can be done from the front end as well: Document Properties - tab Number. That is, you can change format without reloading.