How do I change text in script to number format

Wed, 24 Feb 2010 23:34:30 GMT

I have a field in access that is a "text" format for year but it is all numbers. I cannot change my access dbase for reasons no need to go in to.

in the script I have the below. How do I tell qlikview to treat 'Fiscal Year' as a number and not text?

LOAD

`Fiscal Year`

`Fiscal Quarter #`

`Fiscal Year and Quarter`

`Week # in FQ`

`Solutions Division`

`WWS Area`

`Product Class`

`CSLT Desc`

`Subscription Indicator`

`Market Group`

Region

`Customer Type`

`Reseller #`

`Reseller Name`

`Sales Region`

`Sub Region`

Country

`Distributor #`

`Distributor Name`

`Total Seats`

`Total Booked`

`License Type`

`Salesbook Cust Seg and Lic Type`

`Total Revenue`

`Total Billed`

`Service Sales Type`

`License Group`

`License`

`PIP Type`

Mart

`Sales Team`;

SQL

SELECT

FROM

QrySellThrough;

rwunderlich — Thu, 25 Feb 2010 00:58:29 GMT

You'll usually get the behavior you want with QV without explicitly casting to num, but if you need to:

num("Fiscal Year") as "Fiscal Year"

-Rob

topic How do I change text in script to number format in QlikView