topic Re: Convert from Varchar to Number in QlikView

Convert from Varchar to Number

jood_ahmad — Sun, 10 Jan 2016 11:35:13 GMT

Dears,

Good day and i hope you are in good health.

how can i convert the varchar to number like if i have this data in the data source table (5.1 ,5.2 ,......., 5.9 , 5.10 , 5.11) the same dara is appear in my QV but the issue is with all value that have (5.10 ,5.20 , 5.30 ) i try to convert it to number but still the seam issue.

any ideas about this.

this is a sample of my data. i try to convert it to number but still the same issue

Message was edited by: Ahmad Kastero

Re: Convert from Varchar to Number

HirisH_V7 — Sun, 10 Jan 2016 14:06:33 GMT

Hi,

It working fine. problem? post your sample data .

-Hirish

Re: Convert from Varchar to Number

settu_periasamy — Sun, 10 Jan 2016 14:23:05 GMT

Maybe try

Num(Num#(Field, '#'),'#.000') as field

Re: Convert from Varchar to Number

petter — Sun, 10 Jan 2016 14:57:07 GMT

Is it the different number of decimals that cause a problem for you?

Re: Convert from Varchar to Number

HirisH_V7 — Sun, 10 Jan 2016 15:01:06 GMT

Hi,

SET DecimalSep='.';

in your defined Variables.

Is it Same do check.

-Hirish