
Re: Formatting Numbers in a KPI  Qliksense
Shraddha Gajare Nov 1, 2017 5:42 AM (in response to Darryn Varner)Try
if(Sum(Sales) > 1000000, num(Sum(Sales)/1000000, '#.##0M'),
if(Sum(Sales) > 1000, num(Sum(Sales)/1000, '#.##0K'), num(Sum(Sales), '#.##0')))

Re: Formatting Numbers in a KPI  Qliksense
Darryn Varner Nov 1, 2017 6:04 AM (in response to Shraddha Gajare )The expression still gives me the same result but there is still no symbol in my KPI.
The issue is not the result its that the chart just decides on its own to exclude the symbols


Re: Formatting Numbers in a KPI  Qliksense
Aehman K Nov 1, 2017 10:01 AM (in response to Darryn Varner)=num(if(Sum(Sales) > 1000000, Sum(Sales)/1000000 , '$#,##0.00 M'),
num(if(Sum(Sales) > 1000, Sum(Sales)/1000, '$#,##0.00 K'), num(Sum(Sales), '$#,##0.00')))

Re: Formatting Numbers in a KPI  Qliksense
Darryn Varner Nov 2, 2017 2:17 AM (in response to Aehman K)Hi Aehman,
The calculation is perfect and works great for the Value but not for the custom symbol in a simple KPI chart or Bar chart.
I get the correct value eg if the answer is 535 000 000, with the calculation I get 535Mn in the flat table otherwise in the KPI chart I get 535 (Without the symbol).
The loss of the symbol in the chart is my issue.
Does that make sense?
Darryn

Re: Formatting Numbers in a KPI  Qliksense
Aehman K Nov 2, 2017 12:55 PM (in response to Darryn Varner)Maybe cus the expression was wrong?
I used
=if(Sum(Sales) > 1000000, num(Sum(Sales)/1000000 , '$#,##0.00 M'),
if(Sum(Sales) > 1000, num(Sum(Sales)/1000, '$#,##0.00 K'), num(Sum(Sales), '$#,##0.00')))
and it gives me K or M.
However you need to adjust number of 0 when you dividing the sum(Sale) to make sense of those symbols.

