1 Reply Latest reply: Feb 13, 2013 7:48 AM by Alessandro Saccone RSS

    exponential value returns text

      I have a script with SQL query to Analysis Services database, and the problem is with one of the metrics I choose, when the query return a exponential value like (4.5045045045045043E-2)  qlikview assume that is a text.

       

      CityMetric AMetric BMetric C
      XXX0,00000000%3,96825397%4.5045045045045043E-2
      XXX 31,57894737%31,57894737%
      XXX 31,57894737%31,57894737%

       

      how can i change that direct in the script.

       

       

       

      SQL SELECT

      {

      [Measures].[Metric A],

      [Measures].[Metric B],

      [Measures].[Metric C]

      }

       

      DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON EMPTY

      CrossJoin(({

      [City].Children}),

      [Day].Children))

       

       

      ON ROWS  FROM

      (SELECT ({[Year].&[2012],[Year].&[2013]})

       

      ON COLUMNS  FROM [G])

       

      WHERE (

      [Company].&[283],

      [Nature Type].&[O])

      CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS

      ;