Re: convert from text to number - Qlik Community

Paknanarn23 · ‎2023-03-13

I want to convert a Text value to a Number value and be able to calculate the converted value

MayilVahanan · ‎2023-03-14

Hi

Try like below

Num(Num#(urfield, '#,##0;#,##0-'), '#,##0;-#,##0') as urfield

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

mominh_uzaifa · ‎2023-03-14

Hello

Try This

if(FindOneOf(FieldName,'-'),'-'&Replace(FieldName,'-',''),Num(Num#(FieldName,'##########0.00'),'##,##,#0.00')) as FieldName

Thanks & Regards,

Huzaifa Momin

convert from text to number