Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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);
Thanks!