Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paulyeo11
Valued Contributor II

QS display 1G How to make it display 1B

HI All

Can some one advise me how to do the above ?

THis happen on Chart Y Axis

paul

1 Solution

Accepted Solutions
lakshmikandh
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi,

Just tried this today,

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

9 Replies
chooco_co
Valued Contributor

Re: QS display 1G How to make it display 1B

paulyeo11
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi Marco

Thank you for the link.

I have read thru.

Since my chart have value from Low to high , look like it is not so easy to make it G to B.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

lakshmikandh
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi,

you can just divide the number in expression and use custom formatting

attach.png

paulyeo11
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi Sir

thank you very much for your suggestion. I think it will work.

But then I am display sales by company, some of the company their sales per year only 1 milllion , some are 1 billion . So if I follow your way it will display all in billion Right ?

Paul

paulyeo11
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi All

Enclosed my QVF file , notice the chart which display G , when i select competitor_k = swiber.

When i click on ADL , it does not have any issue.

Now every thing is okay . if G can be change to B.

Paul

lakshmikandh
Valued Contributor II

Re: QS display 1G How to make it display 1B

Please try some other extension like this which allow the K/M/B instead of K/M/G

GitHub - danielpierre/qlik-sense-dygraphs: A dygraphs chart extension for Qlik Sense

lakshmikandh
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi,

Just tried this today,

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

paulyeo11
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi Lak

Thank you very much for your offer , I will try it out. Hope that it work.

And look like using extension is cannot be avoid and look like using cloud is still a lot of limitation.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

paulyeo11
Valued Contributor II

Re: QS display 1G How to make it display 1B

Hi Lak

I just click the link and i notice that it is not so simple , so i think i need to look for other alternative to make G change to B. Thank you.

Paul