Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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!