Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: Convert currency to show in K

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.

Re: Convert currency to show in K

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

Re: Convert currency to show in K

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

Re: Convert currency to show in K

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.

MVP
MVP

Re: Convert currency to show in K

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

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

Community Browser