Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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','.',',')