topic Re: convert from text to number in QlikView

convert from text to number

Paknanarn23 — Tue, 14 Mar 2023 03:19:20 GMT

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

MayilVahanan — Tue, 14 Mar 2023 04:04:47 GMT

Try like below

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

mominh_uzaifa — Tue, 14 Mar 2023 05:18:47 GMT

Hello

Try This

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

Thanks & Regards,

Huzaifa Momin