topic Re: Number format into Milion in QlikView

Number format into Milion

Wed, 10 Jun 2015 09:55:46 GMT

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 — Wed, 10 Jun 2015 10:23:02 GMT

Hi,

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

send me ur mail id

CELAMBARASAN — Wed, 10 Jun 2015 10:26:14 GMT

Go to chart properties-->Number tab

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

Wed, 10 Jun 2015 10:29:23 GMT

fvelascog72 — Wed, 10 Jun 2015 10:33:42 GMT

Hi,

Try in Expression:

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

prajapatiamar38 — Wed, 10 Jun 2015 10:38:57 GMT

Hi..

GO to Chart Properties>Number tab

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

Thanks

help4qv123 — Wed, 10 Jun 2015 10:42:31 GMT

This is the exp

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