Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am supposed to use 'B' instead of 'G' that appears in KPI when value exceeds billion. There is a similar question posted already in this link. But no one has answered. I am wondering if anyone knows- how to do this?
Thanks.
See this discussion: Re: Qlik Sense KPI Number Format Auto
=pick(ceil(log10(sum(Sales))/3),
num(sum(Sales),'#,##0.0'),
num(sum(Sales)/1000,'#,##0.0 K'),
num(sum(Sales)/1000000,'#,##0.0 M'),
num(sum(Sales)/1000000000,'#,##0.0 B')
) & ''
I agree, and even though the workaround expressions are doable. They must be done on each visualization. Why cant we simply change this at the INI or code level to address this on a macro level. It is just one letter sitting somewhere...
Hi,
You can change the auto number formatting symbol from "G" to "B" in javascript
Please check this Steps to Change : Qlik Sense - Billions number format 'G' to 'B'
Thanks,
Lakshmikandh
Hi Gysbert,
Could this be expanded to override the other qlik numerical label conventions such as µ and m used in a map legend when the values are very small? I'd rather show the decimal values or even scientific notation than use these labels since most people don't understand what they mean in regards to the number format.
Thanks!
Perhaps something like this:
=pick(ceil(log10(sum(Sales))/3)+3,
num(sum(Sales)*1000000000,'#,##0.0 n'),
num(sum(Sales)*1000000,'#,##0.0 µ'),
num(sum(Sales)*1000,'#,##0.0 m'),
num(sum(Sales),'#,##0.0'),
num(sum(Sales)/1000,'#,##0.0 K'),
num(sum(Sales)/1000000,'#,##0.0 M'),
num(sum(Sales)/1000000000,'#,##0.0 B')
) & ''