Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
drminaker
Not applicable

If Match function with AND or OR?

Hi,

Can someone please tell me if it's possible to use AND or OR with a the Match function?

I'm trying to create a custom dimension where I want to pull records from staff who are [Active] and in [Toronto] and name this as 'Available/Toronto'.


The match statements work fine on their own, but I need to combine them using AND. I've tried using several different ways to do this and can't get it to work. Any help, much appreciated.

if(match([Status],'Active'), 'Available/Toronto'

if(match([Location],'Toronto), 'Available/Toronto'

Thanks!

R.

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: If Match function with AND or OR?

May be like this:

If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)

2 Replies
sunny_talwar
Not applicable

Re: If Match function with AND or OR?

May be like this:

If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)

drminaker
Not applicable

Re: If Match function with AND or OR?

Perfect, thank you so much!

I must have had a comma or parentheses in the wrong place or something. I searched all over trying to find an example of something this basic and wasn't able to. I'll be sure to bookmark this for another time!

R.