Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Nemo1
Creator II
Creator II

Format number in table

hello everyone, this is rather an easy question but i am not being able to solve this.

I have a table, where my values are being displayed as this "$58395" but i would like to have them as this "$58,3K". How can i do that? 

the format pattern right now looks like this: #.##0 €;-#.##0 € . I played around with it but i just dont get it. 

 

thanks

Labels (4)
2 Replies
PrashantSangle

use num()

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
BrunPierre
Partner - Master II
Partner - Master II

Try

=Money('$58395'/1000, '$#,##0.0K')