Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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