Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
LSRI24
Contributor
Contributor

Formula issue

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!

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi,

Try this:

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

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

Jordy

Climber 

Work smarter, not harder

View solution in original post

4 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

Try this:

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

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

Jordy

Climber 

Work smarter, not harder
saminea_ANZ
Creator
Creator

If i understand correctly, Perhaps this?

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

miskinmaz
Creator III
Creator III

LSRI24
Contributor
Contributor
Author

Thank you!