Discussion board where members can get started with Qlik Sense.
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.:
LOAD * FROM [lib://QVDSourcePath/Aurora_WorkflowStatus.qvd] (qvd)
WHERE Workflow_Area='Cheque Scanning'
or Workflow_Area='Sales Tracker'
or Workflow_Area='Task Management'
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)?
Go to Solution.
You have to write like below,
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
You can also do this
LOAD * INLINE [
FROM [lib://QVDSourcePath/Aurora_WorkflowStatus.qvd] (qvd)