Format currency as a KPI

[Anonymous]

Hello,

I have this situation:

R$

100

1.000

1.000.000

1.000.000.000

And using this expreesion I can treat and show the same values, but with another mask in a KPI:

100

R$ 1 K

R$ 1 M

R$ 1 B

But when I look the 100, i don't have the currency format.

I need help

Expression:

if(Sum(valor) < 1000000000,  num(Sum(valor)/1000000000, 'R$ #.##0', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'),

if(Sum(valor) > 1000000,  num(Sum(valor)/1000000, 'R$ #.##0', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'),

if(Sum(valor) > 1000, num(Sum(valor)/1000,  'R$ #.##0', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'),

(num(Sum(valor), 'R$ #.##0,', ',', '.') & pick(floor(log10(sum(valor))/3)+1,'',' K',' M',' B'))

)))

[MK_QSL]

This is what you can try..

Scaling Numbers and DSE Tips | Qlikview Cookbook

[#3]

You can try with Money function instead of Num. Also can you please post sample qvw to better understand the issue?