topic Format Number in QlikView

Format Number

fkeuroglian — Tue, 09 Sep 2014 15:29:03 GMT

Hi, expert i recieved numbers in this strange format

how i can cast or convert to int??

attach excel with example and qvw using this excel

Thank you a lot

Fernando

Re: Format Number

MarcoWedel — Tue, 09 Sep 2014 15:32:30 GMT

Hi,

works without any special effort if you adjust your DecimalSep:

SET DecimalSep='.';

hope this helps

regards

Marco

Re: Format Number

Tue, 09 Sep 2014 15:35:16 GMT

Hey

I just loaded the data in a qv file and it seems to work. See attached.

Re: Format Number

fkeuroglian — Tue, 09 Sep 2014 15:40:44 GMT

Marco and Koushik it seems to be a format issue, i change what you tell me (set decimal) and work ok, but if i want that my thousand separator is the "." and my decimal separator will be ","???

i have problems changing this

Thank you a lot Marco and Koushik

Fernando

Re: Format Number

Tue, 09 Sep 2014 15:50:44 GMT

Hey Fernando

I dont seem to understand your question. can you elaborate?

Regards

Koushik

Re: Format Number

MarcoWedel — Tue, 09 Sep 2014 16:08:44 GMT

Hi,

try

Num(Num#(Numero, '' ,'.',',')) as Numero

regards

Marco

Re: Format Number

ashfaq_haseeb — Tue, 09 Sep 2014 16:18:09 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ