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: 
qlikviewaf
Creator
Creator

Amount Format - Only thousand

Hi Guys,

in my table the money format are shown as 54.543,52 i would like to have only thousand like 55 K $

i tried to modify the format pattern without success, how this should be configured?
Thank you!

amount format 2.PNGamount format.PNG

6 Replies
sunny_talwar

May be use Expression Default formatting with something like this

Num(YourExpression/1000, '## K $')

qlikviewaf
Creator
Creator
Author

Thank you for your reply.

Is not working

sunny_talwar

Would you be able to share a screenshot or a sample?

oscar_ortiz
Partner - Specialist
Partner - Specialist

In your expression divide by 1000 as Sunny has mentioned.

Then go to your number tab and modify your number format as follows:

264258-1.PNG

Should give you the results you're looking for.

264258-2.PNG

Good luck!

Oscar

antoniotiman
Master III
Master III

Try

Num(Field/1000,'#.##0 K $')