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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III
‎2021-01-22 04:25 PM

If Match

Hello,

 

Im trying to pull the data which fits the criteria for 2 different data sets, but having a hard time implementing the or to combine both criteria. 

=((If(Match([Case Stage],'App/Add Overdue','Recert Overdue','AMS Update'),
[Case Stage])))

or

((If(Match([Expedited Case Stage],'App'),
[Expedited Case Stage])))

Thank you

668 Views
0 Likes
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2021-01-23 05:38 AM

Perhaps this?

=If(Match([Case Stage],'App/Add Overdue','Recert Overdue','AMS Update'), [Case Stage], If(Match([Expedited Case Stage],'App'), [Expedited Case Stage]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

633 Views
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2021-01-23 05:38 AM

Perhaps this?

=If(Match([Case Stage],'App/Add Overdue','Recert Overdue','AMS Update'), [Case Stage], If(Match([Expedited Case Stage],'App'), [Expedited Case Stage]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
634 Views