Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
zwyne
Contributor

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

Re: String manipulation

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

-Rob

4 Replies

Re: String manipulation

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

-Rob

zwyne
Contributor

Re: String manipulation

Thank you Rob
Community Manager
Community Manager

Re: String manipulation

Hi, Is this for QlikView or Qlik Sense. Although answered I'd like to move it into the appropriate product forum. Thanks
Sue Macaluso

Re: String manipulation

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

-Rob

Community Browser