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;
