Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
enricocamerin
Creator
Creator

Format to number after export to excel

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

Labels (2)
1 Solution

Accepted Solutions
Hania
Creator
Creator

hii,

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

then you export it into excel it works fine.

Hania_0-1681807470181.png

 

Hope this helps,

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

View solution in original post

4 Replies
sandeep-singh
Creator II
Creator II

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
];

sandeepsingh_0-1681753254583.png

 

 

 

enricocamerin
Creator
Creator
Author

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
Creator II
Creator II

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. 

sandeepsingh_0-1681804944852.png

 

Hania
Creator
Creator

hii,

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

then you export it into excel it works fine.

Hania_0-1681807470181.png

 

Hope this helps,

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