Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
gsaipran
New Contributor II

Display Number as it is in data source

I have a contact number with spaces in between like 080 238 3923.

When I use that column in Qlik Sense, its displaying as 802383923

I want to display as original format in  App.

May i how can that be done.

Thanks in Advance,

Pranathi.

Labels (2)
3 Replies
saminea_ANZ
New Contributor III

Re: Display Number as it is in data source

Can you try to use Text

Channa
Contributor III

Re: Display Number as it is in data source

=purgechar('080 238 3923 ',' ')

it will remove space

Channa
gsaipran
New Contributor II

Re: Display Number as it is in data source

still not working