Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pbower1989
New Contributor

Multiple OR Statement Filters

Hi all,

I looked up threads but perhaps didn't phrase the question right.

What is the quick way in Qlik Sense to do multiple OR statements, e.g.:

Aurora_Workflow:

LOAD * FROM [lib://QVDSourcePath/Aurora_WorkflowStatus.qvd] (qvd)

WHERE Workflow_Area='Cheque Scanning'

or Workflow_Area='Membership'

or Workflow_Area='Manual'

or Workflow_Area='Practice'

or Workflow_Area='Sales Tracker'

or Workflow_Area='Task Management'

or Workflow_Area='Cessation'

or Workflow_Area='Unknown';

How do I just go 'WHERE' and then do something in Brackets that does the same thing (bring back a table with all of these in it)?

Thanks

1 Solution

Accepted Solutions
devarasu07
Honored Contributor II

Re: Multiple OR Statement Filters

Hi,

You have to write like below,

LOAD * FROM [lib://QVDSourcePath/Aurora_WorkflowStatus.qvd] (qvd)

WHERE match(Workflow_Area,'Cheque Scanning','Membership','Manual','Practice','Sales Tracker','Task Management','Cessation','Unknown');


also check this article,

Using IN clause in QlikView – Learn QlikView


Hope this helps to youSmiley Happy


Thanks,

Deva

3 Replies
devarasu07
Honored Contributor II

Re: Multiple OR Statement Filters

Hi,

You have to write like below,

LOAD * FROM [lib://QVDSourcePath/Aurora_WorkflowStatus.qvd] (qvd)

WHERE match(Workflow_Area,'Cheque Scanning','Membership','Manual','Practice','Sales Tracker','Task Management','Cessation','Unknown');


also check this article,

Using IN clause in QlikView – Learn QlikView


Hope this helps to youSmiley Happy


Thanks,

Deva

MVP
MVP

Re: Multiple OR Statement Filters

You can also do this

LOAD * INLINE [

Workflow_Area

Cheque Scanning

Membership

Manual

Practice

Sales Tracker

Task Management

Cessation

Unknown

];

Aurora_Workflow:

LOAD *

FROM [lib://QVDSourcePath/Aurora_WorkflowStatus.qvd] (qvd)

WHERE Exists(Workflow_Area);

pbower1989
New Contributor

Re: Multiple OR Statement Filters

Thanks!