Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Go to Solution.
May be like this:
If(Match([Status],'Active') and Match([Location],'Toronto'), 'Available/Toronto', FalseCondition)
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!