6 Replies Latest reply: Aug 26, 2015 9:36 AM by Chaitanya Pericherla

# Show money values in billions as abbreviated decimal value

Hello my qlikview friends.  I would like to know if it is possible to abbreviate the values on the Y-axis in a chart in millions and billions as, for example, instead of \$100,000,000 as \$100M, or \$1,100,000,000 as \$1.1B?

• ###### Re: Show money values in billions as abbreviated decimal value

Num(value/1000000, '###.##') & 'M' or you can change the number format as Million or Billion as below

• ###### Re: Show money values in billions as abbreviated decimal value

Hi,

Go to Numbers Tab on your chart properties and look at the right side bottom.

You can give the symbols for Millions and Billions.

Regards,

Kaushik Solanki

• ###### Re: Show money values in billions as abbreviated decimal value

The number tab will allow you to define abbreviations and symbols for your currency, as well as Thousands, Millions, and Billions.  The Axis is adjusted accordingly based on which abbreviations you use.  For US Dollars, the abbreviations I use for all of the denominations are \$, \$K, \$M, \$B

• ###### Re: Show money values in billions as abbreviated decimal value

Thank you both for the quick replies.  Is it possible to only have an abbreviated number in the axis but not the actual values on the data labels of a line chart.  I want to show the line chart label values as they actually are, but abbreviate the axis values.

• ###### Re: Show money values in billions as abbreviated decimal value

The axis will scale on abbreviation and the hover value is based on the number format defined

• ###### Re: Show money values in billions as abbreviated decimal value

Other way around is Duplicate the same expression and display it as Text as Pop-Up and in number show it as expression default.So the axis number is abbreviated and popup will show the original value when you hover over the data point.