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

Format currency as a KPI

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'))

)))

2 Replies
MK_QSL
MVP
MVP

Not applicable
Author

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