topic Amount Format - Only thousand in QlikView

Amount Format - Only thousand

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 15 Jun 2017 13:59:24 GMT

May be use Expression Default formatting with something like this

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

qlikviewaf — Thu, 15 Jun 2017 15:40:37 GMT

Thank you for your reply.

Is not working

sunny_talwar — Thu, 15 Jun 2017 15:48:16 GMT

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

oscar_ortiz — Thu, 15 Jun 2017 15:54:01 GMT

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 — Thu, 15 Jun 2017 15:54:21 GMT

Try

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

MarcoWedel — Fri, 16 Jun 2017 00:57:36 GMT

Hi,

maybe helpful:

regards

Marco