Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For G to B format display, Expression with If and Num is not working Qlik Sense Chart- Bar. Did anyone try this in charts?
Sorry, what do you mean by "G to B" ?
Andy
Auto format of Billion no: 'G' to 'B' in charts
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
It is helpful but we had other issue with SI Units of decimals as well, for example :10^(-6).
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