Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gsaipran
Contributor II
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
Creator
Creator

Can you try to use Text

Channa
Specialist III
Specialist III

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

it will remove space

Channa
gsaipran
Contributor II
Contributor II
Author

still not working