topic Re: Loading a numeric value with decimal point instead of comma in QlikView

Loading a numeric value with decimal point instead of comma

Mon, 29 Feb 2016 13:18:29 GMT

Hi how would I load a field containing numeric values in the form 00.00 as opposed to how it currently stands ie 00,00 ?

Thanks

Re: Loading a numeric value with decimal point instead of comma

sunny_talwar — Mon, 29 Feb 2016 13:21:32 GMT

May be change these setting around:

SET ThousandSep='.';

SET DecimalSep=',';

Re: Loading a numeric value with decimal point instead of comma

jonathandienst — Mon, 29 Feb 2016 13:23:55 GMT

If you don't want to change the default values for the decimal and thousands separators, load the value like this:

...

Num(Num#(myField, '#.##0,00', ',', '.')) As myField,

...

Re: Loading a numeric value with decimal point instead of comma

Mon, 29 Feb 2016 13:24:32 GMT

Thanks Sunny - It works, however I should mention I only want to change it for this particular field ? I dont want it to affect what I currently have in other fields