Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How do I change text in script to number format

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;





Tags (1)
1 Reply

How do I change text in script to number format

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

Community Browser