Qlik Community

App Development

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

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Creator
Creator

If statement with multiple Match clauses

I have an If statement that is formed like this:

 

=if(
(Match([Stage],'Active')) and
(Match([OFFICE_CODE], $(vFilterCode)))
, [Description])

$(vFilterCode) is 'AAA', 'BBB', 'CCC', 'DDD'

It expresses to this:

If((Match([Stage],'Active')) and (Match([OFFICE_CODE], 'AAA', 'BBB', 'CCC', 'DDD')) ,[Description])

I am using this to build a pie chart, however when I load up the pie chart, it appears to filter on Stage = Active and OFFICE_CODE = 'AAA', it doesn't appear to check BBB, CCC, or DDD.

I am sure I have a syntax error somewhere.

Any ideas?

0 Replies