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: 
Fabien
Contributor III
Contributor III

Use of Match() & Concat() functions together

Hi all,

I'm working on integrating the following to my existing script however I am getting an 'Invalid Expression' error when loading the data, any ideas why? 😬

 

If(Match(Concat(POL_MAIN_BUSINESS_ZONE,POD_MAIN_BUSINESS_ZONE),


'MID EAST-IND CONFAR EAST',
'MID EAST-IND CONMID EAST-IND CON',
'FAR EASTFAR EAST',
'MID EAST-IND CONFAR EAST'),


'Out of Scope',
'Within Scope') as Scope

 

In addition to this code i would like to add an exception to this, that is, if within the POL_MAIN_BUSINESS_ZONE or POD_MAIN_BUSINESS_ZONE = FAR EAST and that POL_COUNTRY or POD COUNTRY = TIMOR then it should be flagged as Within Scope otherwise Out of Scope.

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Maybe try this:

If(Match(POL_MAIN_BUSINESS_ZONE&' '&POD_MAIN_BUSINESS_ZONE,


'MID EAST-IND CONFAR EAST',
'MID EAST-IND CONMID EAST-IND CON',
'FAR EASTFAR EAST',
'MID EAST-IND CONFAR EAST'),


'Out of Scope',
'Within Scope') as Scope

View solution in original post

2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Maybe try this:

If(Match(POL_MAIN_BUSINESS_ZONE&' '&POD_MAIN_BUSINESS_ZONE,


'MID EAST-IND CONFAR EAST',
'MID EAST-IND CONMID EAST-IND CON',
'FAR EASTFAR EAST',
'MID EAST-IND CONFAR EAST'),


'Out of Scope',
'Within Scope') as Scope

Fabien
Contributor III
Contributor III
Author

Nice one Arthur, thanks for that. 🙂