topic Text to Num in QlikView

Text to Num

Tue, 27 Apr 2010 10:07:45 GMT

I get a table form a site

I get text and numbers in the table Dollar

How can i get the text into Num?

Tue, 27 Apr 2010 10:13:45 GMT

Use the Num# function to convert text to number.

Tue, 27 Apr 2010 10:14:08 GMT

hi,

probably you can use num(Dollar) to convert text to numbers.

thanx

prabhu0505 — Tue, 27 Apr 2010 10:25:03 GMT

In properties dialog box of all the sheet object, you can find Number tab where you can override the document's default data type.

prabhu0505 — Tue, 27 Apr 2010 11:19:57 GMT

another thought and also this seems to be closer


dual
Date# (text [, format])

Tue, 27 Apr 2010 11:59:54 GMT

i got this now

but this isn't what I want

LOAD

Date,

textbetween

(Date,', ',',') as datum,

num#

(Close,'#0,##',) as dollar

FROM

[http://www.fxstreet.com/forex-tools/rate-history-tools/?days=15&pair=eurusd]

(

html, codepage is 1252, embedded labels, table is @2)

;