1 Reply Latest reply: Feb 24, 2010 7:58 PM by Rob Wunderlich RSS

    How do I change text in script to number format

    dcpy

      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;