Discussion Board for collaboration related to QlikView App Development.
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?
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?
NUM(If(CONDICION>=1000,1,0)) AS FIELD,