Formatting money to display in millions

[#1]

Hi All,

I have financial information which I want to display in full detail on a table and in summary format in charts.

In excel I would format the chart to display as €#.0##,,"M" to change 1,500,000.00 into €1.5M.

How do I do the same in Qlikview?

Thanks,

A

[sivarajs]

num('1,500,000'/1000000,'€ #.# M')

[er_mohit]

if you are using chart or any table then Go to properties -->number tab-->

then on tha field tick on radio button for money and in symbol write M

hopeit helps