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?
num('1,500,000'/1000000,'€ #.# M')
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
Retrieving data ...