Text to Num

[markus19-85]

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

[Anil_Babu_Samineni]

Is this not working?

Num(num#(401,67))

[markus19-85]

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

[tresB · Accepted solution]

Try like:

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

[markus19-85]

wow thanks, its working 🙂

[edwin]

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

[markus19-85]

Hi, here are my seetings 

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

[edwin]

thumbs up