topic Re: Where Condition help in QlikView

Where Condition help

amit_saini — Fri, 22 Jun 2018 14:07:23 GMT

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,

Re: Where Condition help

sunny_talwar — Fri, 22 Jun 2018 14:10:57 GMT

May be using Match

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

Re: Where Condition help

YoussefBelloum — Fri, 22 Jun 2018 14:11:46 GMT

Hi,

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

Re: Where Condition help

marcus_sommer — Fri, 22 Jun 2018 14:12:18 GMT

Maybe in this way:

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

- Marcus

Re: Where Condition help

sunny_talwar — Fri, 22 Jun 2018 14:13:41 GMT

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