Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exporting numbers to Excel from a straight table AS NUMBERS not text

I'm getting numbers formatted as text by Excel when exporting from a straight table into Excel.

I bet there's a simple way to make Excel format them as numbers.

Who knows the answer?

John

3 Replies
el_aprendiz111
Specialist
Specialist

Hi

-Num(sum(Value), '#.##0')

-sum(value)*1

Anonymous
Not applicable
Author

It works to use num().  Thanks.

Why is this necessary?

It is needed when I do something in my load script like

if(condition,1,0) as condition_count

Doesn't need to be used when just reading in a number from a table.

Can you explain?

John

el_aprendiz111
Specialist
Specialist

Hi,

exaple:

Script:

NUM(If(CONDICION>=1000,1,0)) AS FIELD,