Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
origao1986
Contributor
Contributor

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

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