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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formating Names

Hi All

Im working on this project but in the name field there's digits and commas and wierd information. Is there maybe a formula that I can hide all those items that are not names but without deleting the information?

Thanks

1 Solution

Accepted Solutions
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi Blaze,

the functions Left, Right, Mid, Len and Subfield allows you, to find a string and to extract only value, you want to show.

View solution in original post

1 Reply
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi Blaze,

the functions Left, Right, Mid, Len and Subfield allows you, to find a string and to extract only value, you want to show.