topic Re: Text to Num in QlikView

Text to Num

markus19-85 — Tue, 29 Dec 2020 13:50:36 GMT

Hi all,

I would like to format a text 401,67- into a number. I an older QlikView 11 application it is working with the num#() function, but not in QlikView 12 April 2019 SR1

I attached an example, hope you guys can help

Thanks and Regards,

Markus

Re: Text to Num

Anil_Babu_Samineni — Tue, 29 Dec 2020 13:58:05 GMT

Is this not working?

Num(num#(401,67))

Re: Text to Num

markus19-85 — Tue, 29 Dec 2020 14:02:13 GMT

it still should be a negative number. If i use num(num#(02) the negative numbers disapear and i only have 584,13

Re: Text to Num

tresB — Tue, 29 Dec 2020 14:15:22 GMT

Try like:

Num(Num#(yourNum, '0;0-'))

Re: Text to Num

markus19-85 — Tue, 29 Dec 2020 14:17:21 GMT

wow thanks, its working 🙂

Re: Text to Num

edwin — Tue, 29 Dec 2020 18:10:10 GMT

@markus19-85 just curios, what decimal separator do you have in your settings? is it comma or period?

Re: Text to Num

markus19-85 — Wed, 30 Dec 2020 08:13:51 GMT

Hi, here are my seetings

SET ThousandSep='.';
SET DecimalSep=',';

Re: Text to Num

edwin — Wed, 30 Dec 2020 14:11:37 GMT

thumbs up