Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mmarchese
Creator II
Creator II

Money format like $123,456k?

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

  1. a dollar-sign prefix
  2. thousands-separator commas
  3. 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
1 Solution

Accepted Solutions
nicu1996
Contributor III
Contributor III

3 Replies
nicu1996
Contributor III
Contributor III

You can try:

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

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

mmarchese
Creator II
Creator II
Author

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?
nicu1996
Contributor III
Contributor III

I prefer to use it when I load the data.

 

Yes, you can format by using this setup:

expression.png

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.