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

KPI Object show $ and K/M

Hi all,

I would like to show a KPI with dollar and in thousand or million dynamically.

However, i found that it could only show one of them.

Is it possible to show both dynamically?

Best Regards,

Louis

4 Replies
rahulpawarb
Specialist III
Specialist III

May be this:

='$' &

If(Sum(Value) < 999,

   Sum(Value),

   If(Sum(Value) > 999 AND Sum(Value) < 99999,

      Num(Sum(Value)/1000, '#,##0.##') & ' K',

      If(Sum(Value) > 99999,

      Num(Sum(Value)/1000, '#,##0.##') & ' M')))

Regards!

Rahul Pawar

kaanerisen
Creator III
Creator III

Hi,

numberFormat.png

TEXT(if(Sum(Value) >= 1000000000,  num(Sum(Value)/1000000, '$#.##0,##M', ',', '.'),

if(Sum(Value) >= 1000000,  num(Sum(Value)/1000000, '$#.##0,##M', ',', '.'),

    if(Sum(Value) >= 1000, num(Sum(Value)/1000,  '$#.##0,##K', ',', '.'),

    num(Sum(Value), '$#.##0,##', ',', '.')))))

If you want to use on table object, you don't need to use TEXT function.

rubenmarin

Hi, another option:

=Num(Sum(Value)/Pow(10, Floor(Len(Round(Sum(Value)))-1, 3)), '$#,##0.00')

& Pick(Floor((Len(Round(Sum(Value)))-1)/3)

    , ' K'

    , ' M'

  )

Anonymous
Not applicable
Author

After using this expression, the conditional color will not work.