Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hopeit helps