Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to specify a money format that has the following features?
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:
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...
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...
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.