Formula issue

[LSRI24]

How do i convert the following excel formula into Qliksense when adding a calculated field. For this purpose, A1 is in the field "Mobile". Im essentially trying to format a field of mobile numbers to have no spaces and no '0' at the front

=IFERROR(VALUE(SUBSTITUTE(A1," ","")),"")

Thanks for your help!

[JordyWegman · Accepted solution]

Hi,

Try this:

Num(Replace(A1,' ',''))

Excel uses double qoutes, where as Qlik uses single quotes.

Jordy

Climber 

[saminea_ANZ]

If i understand correctly, Perhaps this?

If(IsNum(Replace(A1,  ' ', '')), A1, 'Error') as A1

[miskinmaz]

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Strin...

You can also try to use purge char function

[LSRI24]

Thank you!