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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Showing String/Subsring

Need to show either whole string or substring based on the selection. Below are different scenarios with expected results:

If selected                                                                 Show

Europe, North America|Europe                                Europe

North America, North America|Europe                     North America

Europe, North America                                             Europe, North America

Europe, North America|Europe, North America        Europe, North America

Any ideas.

3 Replies
Not applicable
Author

2 potential solutions attached. Not sure if your actual data is complicated enough to make these fixes insufficient.

Anonymous
Not applicable
Author

Thank you Clark Kipling, unfortunately, i can't edit the script for it, only changes on front end.

Not applicable
Author

The second object doesn't require a script change.