Multiple OR Statement Filters

[Anonymous]

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

[devarasu07 · Accepted solution]

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 you:)

Thanks,

Deva

[sunny_talwar]

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);

[Anonymous]

Thanks!