Conversion

[#1]

Hi,

I have data something like 185012499.98, I want to convert into 185.0 in qlikview. Its a pivot chart and Million and thousands are disabled.

Please help me with this.

I want the above data in this format 185.0. Its in Million

Thanks,

Keerthi KS

[MK_QSL]

=Num(Value / 1000000,'#0.0M')

[jagan]

Hi,

Divide the numbers by million in expression

=Num(Sum(SomeMeasure)/1000000, '#,###.0')

Hope this helps you.

Regards,

Jagan.