measure expression formatting doesn't work in Excel

[Moshiko]

When I create a measure within an object and using measure expression as Number formatting, when I export data to excel from this object, the data in excel is shown as General, not as a number.

I need to convert it to Number manually in Excel file.

the measure is: 

if(%Tonnage_Unit_Code=1,

num((Sum( {< TYPE= {'F'}  $(vIgnorEconomic)>} NET_WEIGHT)/1000),'#,##0'),

if(%Tonnage_Unit_Code=2,

num((Sum( {< TYPE= {'F'}  $(vIgnorEconomic)>} NET_WEIGHT)/1000)

/

(Sum( {< TYPE= {'F'}  $(vIgnorEconomic)>} Total NET_WEIGHT)/1000),'#,##0%')

))

when I write the same measure in Qlik sense on prem, the formatting in correct.

who can help please?

[MatheusC]

@Moshiko 
In your expression condition, Qlik is treating this expression as AUTO, which will cause it to return General in Excel. This will not be possible in your current scenario. In some cases, changing from AUTO to number, custom, or even applying formatting to a single measure like num(sales, '###,#0.0 $') can achieve the desired result when exporting.

However, this does not apply to your case, so this limitation remains. You might want to report your case to Qlik or support an existing idea related to this issue.

- Matheus

[Moshiko]

Hi @MatheusC 

this expression works perfectly in Qlik sense On prem when exporting to excel, why in Qlik Cloud  it's different?