Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amit_saini
Honored Contributor III

Where Condition help

Hi Folks,

How to implement below condition while loading the data:

Project Phase = “Closed”  and Project_Approval = “On Hold” or “Rejected” or “Pending” or “Cancelled”

So i should not load data if Project Phase = “Closed”  is matching with any one of Project_Approval = “On Hold” or “Rejected” or “Pending” or “Cancelled”


Regards,

AS

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Where Condition help

Maybe in this way:

where not ([Project Phase] = 'Closed' and match(Project_Approval, 'On Hold', 'Rejected', 'Pending', Cancelled'))

- Marcus

4 Replies

Re: Where Condition help

May be using Match

Where Project Phase = 'Closed' and Match(Project_Approval, 'On Hold', 'Rejected', 'Pending', 'Cancelled');

YoussefBelloum
Esteemed Contributor

Re: Where Condition help

Hi,

WHERE [Project Phase]=“Closed” and (Project_Approval = “On Hold” or Project_Approval = “On Hold” or Project_Approval = “Rejected” or  Project_Approval = “Pendingor  Project_Approval = “Cancelled);

MVP & Luminary
MVP & Luminary

Re: Where Condition help

Maybe in this way:

where not ([Project Phase] = 'Closed' and match(Project_Approval, 'On Hold', 'Rejected', 'Pending', Cancelled'))

- Marcus

Re: Where Condition help

Didn't see the not... this should work