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: 
Not applicable

Convert currency to show in K

Hi

I have currency as 56,877,786.96

i want to show this as $56,877K in the dashboard.

How can I achieve this in straight table.

Thank you Much for your time.

5 Replies
swuehl
MVP
MVP

Maybe like

='$' & round(CurrencyField/1000) & 'K'

or just

=round(CurrencyField/1000)

and use this

$#,##0K;-$#,##0K

as format pattern for money on number tab for that column.

Gysbert_Wassenaar

You can set the format of the expression on the Number tab. Choose Money and change the Format Pattern to your needs. You can also use the num function around your expression: num(Sum(Value)/1000,'$#,##0K')


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you Much for your reply, but there is one issue.

$56,789 will be $56K but the expression $#,##0K;-$#,##0K

Is showing it as $56,789K

Can you Please see.

Not applicable
Author

Thank you Much for your reply, but there is one issue.

$56,789 will be $56K but the expression $#,##0K;-$#,##0K

Is showing it as $56,789K

Can you Please see.

swuehl
MVP
MVP

You'll need to state the decimal point and thousand separator then in the format function:

=num(56789 / 1000,'$#,##0K','.',',')