Qliksese - Unable to export millions format in export to excel

[Karim_Khan]

Hi,

I have created units to show data into ones,thousands and millions.I am able to export formatted units data when ones and thousands units options are selected and its getting downloaded in same format.

The issue is coming when i select millions unit and try to export tha data by checking Table formatting option its gives and error and when i say Yes then millions format got wiped out in exported excel.

I am using variable to pass this unit dynamically in expression

v_unit_Format =if(Units='Ones',Currency_Pick_v &'#,##0',If(Units='Thousands',Currency_Pick_v &'#,##0.0k',Currency_Pick_v &'#,##0.0m'))

Regards,

KK

[Chanty4u]

= 

If(Units='Ones',

    Sum(Value),

If(Units='Thousands',

    Sum(Value)/1000,

    Sum(Value)/1000000

))

& If(Units='Ones','',

     If(Units='Thousands','

k','m'))

[Karim_Khan]

The above expression will convert the values into text and we cannot do any summation on it while exporting into excel.I have tried below one which is working but problem is that in presenation its appeaRing with double quotes for million units.

=if(Units='Ones', Currency_v & '#,##0',if(Units='Thousands', Currency_v & '#,##0.0k',Currency_v & '#,##0.0"m"'))