Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
praveenavelagap
Contributor III

G to B in Qlik Sense Charts

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

5 Replies
awhitfield
Esteemed Contributor

Re: G to B in Qlik Sense Charts

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

Andy

praveenavelagap
Contributor III

Re: G to B in Qlik Sense Charts

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

lakshmikandh
Valued Contributor II

Re: G to B in Qlik Sense 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

praveenavelagap
Contributor III

Re: G to B in Qlik Sense Charts

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

Capture.PNG

lakshmikandh
Valued Contributor II

Re: G to B in Qlik Sense Charts

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

Community Browser