This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
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
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
Thanks so much. So easy once you pointed that out. Much appreciated.
It can be done from the front end as well: Document Properties - tab Number. That is, you can change format without reloading.