topic Load inline with "," as a decimal separator in QlikView

Load inline with "," as a decimal separator

Wed, 23 Mar 2011 16:45:04 GMT

I want to do this:



[WhatIfPreço]:
LOAD * INLINE [
 Mudança Preço
 -.2
 -.15
 -.1
 -.05
 -.03
 -.01
 0
 .01
 .03
 .05
 .1
 .15
 .2
];

The problem is that the decimal separator is set to "," as I am in Brazil so that does not work as expected.

The question is: How do i write this when the decimal separator is comma?

martin59 — Wed, 23 Mar 2011 16:48:39 GMT

Hi,

You have to do something like this :


table:
LOAD Replace([Mudança Preço],'/',',') as [Mudança Preço]
INLINE [
Mudança Preço
-0/2
-0/15
-0/1
...
];

Hope that helps you

Wed, 23 Mar 2011 17:36:01 GMT

It worked!

Thank you.

rwunderlich — Wed, 23 Mar 2011 21:28:38 GMT

You can specify the delimiter to be used in the load:

] (delimiter is '|') ;

and then use commas in your data.

amien — Wed, 23 Mar 2011 21:56:42 GMT

why not just "2,2" "2,1" etc?

natalia_sterniak — Tue, 03 Dec 2019 07:57:33 GMT

Because ',' will be treated as a separator between new dimensions and values