Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Money Formatting

Hello please I need help with formatting money. Below is what I have 

clipboard_image_2.png

And below is what I have done

clipboard_image_1.png

But I need it to read  $2.47 K. Thanks 

 

1 Solution

Accepted Solutions
y_grynechko
Creator III
Creator III

I am sure there are other ways to just format it in 'Format Pattern' but there is one extra easy way in the measure itself: 

'$' & Num(2468/1000, '###.##') & ' K'

Replace 2468 with whatever you need like this:

'$' & Num(sum(Sales)/1000, '###.##') & ' K'

 

 

View solution in original post

2 Replies
y_grynechko
Creator III
Creator III

I am sure there are other ways to just format it in 'Format Pattern' but there is one extra easy way in the measure itself: 

'$' & Num(2468/1000, '###.##') & ' K'

Replace 2468 with whatever you need like this:

'$' & Num(sum(Sales)/1000, '###.##') & ' K'

 

 

Pomna
Creator III
Creator III
Author

Thank you so much. It worked!