Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Fabien
New 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
Partner
Partner

Re: Use of Match() & Concat() functions together

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
Partner
Partner

Re: Use of Match() & Concat() functions together

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

Highlighted
Fabien
New Contributor III

Re: Use of Match() & Concat() functions together

Nice one Arthur, thanks for that. 🙂