topic Re: Money format like $123,456k? in App Development

Money format like $123,456k?

mmarchese — Thu, 23 May 2019 17:28:42 GMT

Is there a way to specify a money format that has the following features?

a dollar-sign prefix
thousands-separator commas
a k suffix (meaning thousand) no matter what

I want the k suffix to be there all the time, even if the dollar amount is below 1000 or above 1 million. My gut feeling is that I'd prefer not having to divide my numbers by 1000 to get this to work, if possible (i.e. do this purely with formatting), but I'm open to whatever is simplest.

Examples:

123,456,789.12 -> $123,457k
123.45 -> $0k

Re: Money format like $123,456k?

nicu1996 — Thu, 23 May 2019 17:45:00 GMT

You can try:

Money(amount/1000, '$#,##0k', '.' , ',' )

More details here: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Money.htm

Re: Money format like $123,456k?

mmarchese — Thu, 23 May 2019 18:03:34 GMT

Thanks! I assume I should use that 1) during loading for each money field and/or 2) in each money measure. Is that right?

I'm curious, is there a way to achieve this formatting after the fact, by specifying it in the formatting parameters of a visualization?

Re: Money format like $123,456k?

nicu1996 — Thu, 23 May 2019 18:17:07 GMT

I prefer to use it when I load the data.

Yes, you can format by using this setup:

But as I said, I prefer to apply a specific format when the data are loaded - and in the visualization only to display the data.