Amount Format - Only thousand

[qlikviewaf]

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!

[sunny_talwar]

May be use Expression Default formatting with something like this

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

[qlikviewaf]

Thank you for your reply.

Is not working

[sunny_talwar]

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

[oscar_ortiz]

In your expression divide by 1000 as Sunny has mentioned.

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

Should give you the results you're looking for.

Good luck!

Oscar

[antoniotiman]

Try

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

[MarcoWedel]

Hi,

maybe helpful:

Re: Number formatting - millions to billions

Steps to Change : Qlik Sense - Billions number format 'G' to 'B'

regards

Marco