Format to number after export to excel

[enricocamerin]

Dears,

I have a table with the format like 21.39   the point is set as decimal in loading script

when I export to excel it doesn't recognize as a number ad the sum does not work

is there a way to covert ? I tried many format option but it does not work

I don't want to modify the setting in excel or loading script because it is only for this table

thanks

Enrico

[sandeep-singh]

You have to rename your value field to Num(value) field.

Script example:

Decimal:
Load
ID,
num(Value) as Value
;
load * inline [
ID,Value
1,2
2,2.543
3,21.39
4,9.87
5,5.00
];

[enricocamerin]

thank but in qliksense the sum was already working fine. Is when export to excel that it sees the 21.29 as a text or 40 as a text and doesn't do the sum

thanks

[sandeep-singh]

Hi @enricocamerin, Could you please help me a snapshot for excel where you are encountering an issue. I exported the data in excel and it's seems to be working fine for me. 

[Hania · Accepted solution]

hii,

you can also used expression in front end as : num(Sum(Value))

then you export it into excel it works fine.

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!