exponential value returns text

Wed, 13 Feb 2013 12:44:19 GMT

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.

City	Metric A	Metric B	Metric C
XXX	0,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 )

WHERE (

[Company].&[283],

[Nature Type].&)

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

;

Re: exponential value returns text

alexandros17 — Wed, 13 Feb 2013 12:48:08 GMT

try to change the format in the source database (you must look for the correct syntax) not in qv.

Otherwise you can use it as a string, look for the "E" if exists, truncate the string and then multiply for 10, 100, 1000 ... regarding the number after E

Hope it helps

topic exponential value returns text in QlikView

exponential value returns text

Re: exponential value returns text