want to show the expression values in K,M and B

[qliklearnervir]

Hi,

In our project we have one requirement where we want to show the values in data point like 1.5 m, 1.2 m (m is for million ) .

the formula i have used is sum({<matrix={'Life'}>}Actual)  ......and value is showing like 1500000  .

Kindly suggest how can i show the value in qlikview as m,B and K format.

Thanks.

Virendra

[Anonymous]

On the Number tab set the Thousand, Million & Billion Symbols.

[Anonymous]

Replace your expression with:

Num(sum({<matrix={'Life'}>}Actual) / 1000000),'###.##') & 'M'

[MK_QSL]

The Thousand, Million and Billion symbols display available on the Chart axis only.

Straight Tables and Pivot tables do not have any axis hence the symbols do not display.

For Straight table or Pivot table use something like below

IF(SUM(Value)<=100000,SUM(Value)/100000 &'T',

IF(SUM(Value)>=1000000,SUM(Value)/100000 &'M'))

[qliklearnervir]

Hi utkarsh,

if value will be billion and in some months it changes to thousand than.

[buzzy996]

see here,

[simsondevadoss]

Number->Number format settings->interger-> format pattern give it as #,##0K.

But you need to given the condition in expression itself Sum(Sales)/1000

[ashwanin]

Hi

For every format you have to divide your formula with their corresponding numeric values

This one is for million :

=sum({<matrix={'Life'}>}Actual)/ 100000 &'M'

For Thousand (K) Divide the formula by 1000, and for Billion number should be 10000000

[Anonymous]

Here you go,

if(sum({<matrix={'Life'}>}Actual) / 1000000)>1000000, Num(sum({<matrix={'Life'}>}Actual) / 1000000),'###.##') & 'M',

     if(sum({<matrix={'Life'}>}Actual) / 1000000)>1000, Num(sum({<matrix={'Life'}>}Actual) / 1000),'###.##') &           'K', Num(sum({<matrix={'Life'}>}Actual) / 1000),'##.##')))

[qliklearnervir]

after applying this formula my bar is disappeared.

please suggest