Suggest an Idea

[kka_rnishida]

When I use this measure and download as Data, Format is different to Qlik in Excel.

measure：If(Sum(column)<=1,num(sum(column),'#.##'),num(sum(column),'#.###'))

In Excel, this data will be "standard format".
I want these data will be formated as with Qlik Sense.

[Andrew_Kruger]

I ran into this situation recently, my measure in Qlik Sense was set to auto.  When I changed it to the measure format to Number  and set the cutom format it the xls number formatting I was looking for appeared.