topic Re: Number format decimal seperator and thousand seperator in QlikView

Number format decimal seperator and thousand seperator

Anonymous — Tue, 04 Feb 2014 08:24:30 GMT

Hi all,

In my document I use this default settings:

SET ThousandSep: '.';

SET DecimalSep: ',';

I need this settings for the data I load into this document.

Right now I need to add a table file (html) which have numbers in it with a different ThousandSep (',') and a different DecimalSep ('.'). Is there a way to transform this settings when loading the data in a table?

Kind regards,

Henco

Re: Number format decimal seperator and thousand seperator

Tue, 04 Feb 2014 08:29:14 GMT

Try to change the number format of Fields of the table file (html)...

Re: Number format decimal seperator and thousand seperator

maxgro — Tue, 04 Feb 2014 08:30:00 GMT

did you try with ?

Num#( Field, '#', '.', ',') as NewField

Re: Number format decimal seperator and thousand seperator

Sokkorn — Tue, 04 Feb 2014 08:32:18 GMT

Hi Henco,

Here is sample:

Load

Num(PurgeChar(FieldName,'.,' )) As Field,

...

From...

Regards,

Sokkorn

Re: Number format decimal seperator and thousand seperator

Anonymous — Tue, 04 Feb 2014 08:48:58 GMT

Thanks, that helps me out.

Kind regards,

Henco