Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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