Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

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
MVP & Luminary
MVP & Luminary

Re: String manipulation

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

-Rob

4 Replies
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

Re: String manipulation

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

-Rob

Community Browser