Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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.