Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Creator II
Creator II

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