Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be use Expression Default formatting with something like this
Num(YourExpression/1000, '## K $')
Thank you for your reply.
Is not working
Would you be able to share a screenshot or a sample?
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
Try
Num(Field/1000,'#.##0 K $')
Hi,
maybe helpful:
Re: Number formatting - millions to billions
Steps to Change : Qlik Sense - Billions number format 'G' to 'B'
regards
Marco