Number format into Milion

[#1]

Hi,

I am new to qlikview.

I needs to convert into million formate and show on the Y asis as $250M

Example :

250,000,000

I want to show this  as

$250M

How can we show this in above formate ?

Thanks!.

Deepak

[help4qv123]

Hi,

go to chart properties-->number-->select money ...u wil get it....

send me ur mail id

[CELAMBARASAN]

Go to chart properties-->Number tab

Select the Expression and Give Symbol here based on your requirement.

[#4]

de.wadhwa@gmail.com

[fvelascog72]

Hi,

Try in Expression:

num(sum(Value)/1000000,'$#.##0M')

[prajapatiamar38]

Hi..

GO to Chart Properties>Number tab

There you can set the symbol to Millions just write "M".

Thanks

[help4qv123]

This is the exp

num(sum(Value)/1000000,'$#.M')