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]

There was an error in syntax :

=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]

this is working.....but in show data points why m and k is not showing with values.....