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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
zwyne
Creator
Creator

String manipulation

Hello everyone,PFA,

I would like create a create another column called Country from the column Assessment. My expected result is 

AssessmentCountry
AGLB - NBC Tanzania - CANBC Tanzania
AGLB - Ghana - CAGhana
AGLB - Kenya - CAKenya
AGLB - Mauritius - CAMauritius
AGLB - Tanzania - CATanzania
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Trim(SubField(Assessment, '-', 2))  as Country

-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Trim(SubField(Assessment, '-', 2))  as Country

-Rob

zwyne
Creator
Creator
Author

Thank you Rob
Sue_Macaluso
Community Manager
Community Manager

Hi, Is this for QlikView or Qlik Sense. Although answered I'd like to move it into the appropriate product forum. Thanks
Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The question and the answer would be applicable to both products. 

-Rob