Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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
Partner - Master

Try

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