Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

QS How to change 1G to 1B ?

Hi All

In Indonesia Currency :-

1,000,000 = 1M

1000,000,000 = 1B

In QS the Y Axis display as

1,000,000 = 1M

1000,000,000 = 1G

My Question is how to make 1G display as 1B

Paul

1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: QS How to change 1G to 1B ?

‌I take it if you are building a multicurrency dashboard you have career envy table loaded with currency code, symbol maybe exchange rate data to convert to usd just add another field to store the convert to billion value for each currency and then you can use the field rather than a fixed value.

Value / converttobiliion & 'B' hope this idea makes sense.

REgards

Andy

7 Replies
ogster1974
Honored Contributor II

Re: QS How to change 1G to 1B ?

‌Value/1000000000 & 'B' should do the trick.

paulyeo11
Valued Contributor II

Re: QS How to change 1G to 1B ?

Hi Andy

I guess you give me the Value/1000000000 & 'B'  , you are asking me insert this in Expression right ?

My example is consist of only Indonesia data , in my actual QVF file , my data consist of Singapore and Indonesia.

So when i select indonesia , it will work fine , but source - singapore , it will not work.

Paul

ogster1974
Honored Contributor II

Re: QS How to change 1G to 1B ?

‌I take it if you are building a multicurrency dashboard you have career envy table loaded with currency code, symbol maybe exchange rate data to convert to usd just add another field to store the convert to billion value for each currency and then you can use the field rather than a fixed value.

Value / converttobiliion & 'B' hope this idea makes sense.

REgards

Andy

ogster1974
Honored Contributor II

Re: QS How to change 1G to 1B ?

‌Sorry I meant currency table not career envy table predictive text has altos to answer for.

paulyeo11
Valued Contributor II

Re: QS How to change 1G to 1B ?

Hi Andy

Just to confirm are you refer to using below code right ?

WhatIfDimension:

LOAD * INLINE [

What If Dimension Rate8, Column899 

  S$,ORG $

  Org,SGD $

  ];

WhatIfDimension:

LOAD * INLINE [

SOURCE,Currency, Rate

TDSS,SGD, 1

ADL,SGD, 1

TDSPG,RM, 2.6

TDSID,ID,9500

TDSKL,RM, 2.6

TDST,THAI, 25

];

WhatIfDimension:

LOAD * INLINE [

SOURCE,Currency, Rate_

TDSS,SGD, 1

ADL,SGD, 1

TDSPG,RM, 1

TDSID,ID, 1

TDSKL,RM, 1

TDST,THAI, 1

];

ogster1974
Honored Contributor II

Re: QS How to change 1G to 1B ?

yes add another field into that table identifying the convert to billion value and then use that dynamically rather than the fixed value in my first suggestion.

Regards

Andy

paulyeo11
Valued Contributor II

Re: QS How to change 1G to 1B ?

Hi Andy

Your job back ground it is I.T ?

Paul

Community Browser