Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Specialist II
Specialist II

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

View solution in original post

9 Replies
marcohadiyanto
Partner - Specialist
Partner - Specialist

paulyeo11
Master
Master
Author

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
Specialist II
Specialist II

Hi,

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

attach.png

paulyeo11
Master
Master
Author

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
Master
Master
Author

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
Specialist II
Specialist II

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
Specialist II
Specialist II

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
Master
Master
Author

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
Master
Master
Author

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