G to B in Qlik Sense Charts

[Anonymous]

For G to B format display, Expression with If and Num is not working Qlik Sense Chart- Bar. Did anyone try this in charts?

[awhitfield]

Sorry, what do you mean by "G to B" ?

Andy

[Anonymous]

Auto format of Billion no: 'G' to 'B' in charts

[lakshmikandh]

Hi,

You can change the auto number formatting symbol from "G" to "B" in javascript

Please check this https://community.qlik.com/docs/DOC-17461

Thanks,

Lakshmikandh

[Anonymous]

It is helpful but we had other issue with SI Units of decimals as well, for example :10^(-6).

[lakshmikandh]

you can change that also to the symbol you need

k={3:"k",6:"M",9:"B",12:"T",15:"P",18:"E",21:"Z",24:"Y","-3":"m","-6":"μ","-9":"n","-12":"p","-15":"f","-18":"a","-21":"z","-24":"y"}

just substitute the values in reqjuired place in javascript