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: 
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
Sue Macaluso
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob