Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
johnirwin
Contributor
Contributor

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

johnirwin
Contributor
Contributor
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,