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
;
