OR AND statement in Resident

Wed, 12 Mar 2014 14:44:19 GMT

Hi,

The following code with Wrkflow, InputFirst, InputLast and TerminationFirst works well. Under TerminationFirst I want to replace

where Activity_Code = 'NSX'' and State_Code = 'TRM'

with

Where Activity_Code = 'NSX'' or Activity_Code = 'NSA' or Activity_Code = 'SMX' or Activity_Code = 'SMF' or Activity_Code = 'NSS' or Activity_Code = 'SMR' and State_Code

How can I do it please???

Wrkflow:
LOAD   Process_Code ,
Application_id   as   Application_Id ,
Workitem_Id ,
Activity_Code ,
Timestamp ( Txn_Date ) as   Txn_Date ,
State_Code ,
Assigned_User_Id ,
Assigned_Dept_Id ,
Actioned_User_Id ,
applymap ( 'Trays' , Activity_Code , null ()) as   Tray ,
applymap ( 'Trays' , Activity_Code , null ())& State_Code   as   Link ,
if ( State_Code = 'CMP' , timestamp ( Txn_Date ), null ()) as   [CMP_Date]

FROM

( txt , codepage is 1252 , embedded labels , delimiter is '\t' , msq ) ;

InputFirst:
LOAD
Application_Id,
FirstValue(Txn_Date) as InputFirstTimestamp
resident Wrkflow
where Activity_Code = 'NBG' and State_Code = 'RDY'
group by Application_Id
order by Txn_Date;

InputLast:
LOAD
Application_Id,
LastValue(Txn_Date) as InputLastTimestamp
resident Wrkflow
where Activity_Code = 'NBG' and State_Code = 'RDY'
group by Application_Id
order by Txn_Date;

TerminationFirst:
LOAD
Application_Id,
FirstValue(Txn_Date) as TerminationFirstTimestamp
resident Wrkflow
where Activity_Code = 'NSX'' and State_Code = 'TRM'
group by Application_Id
order by Txn_Date;

Re: OR AND statement in Resident

Wed, 12 Mar 2014 14:58:31 GMT

I guess:

Where

(Activity_Code = 'NSX'' or Activity_Code = 'NSA' or Activity_Code = 'SMX' or Activity_Code = 'SMF' or Activity_Code = 'NSS' or Activity_Code = 'SMR')

and State_Code = 'TRM'

Re: OR AND statement in Resident

PrashantSangle — Wed, 12 Mar 2014 15:02:34 GMT

Hi,

Use Bracket() in your script..

Re: OR AND statement in Resident

maxgro — Wed, 12 Mar 2014 15:12:22 GMT

Where

match(Activity_Code, 'NSX', 'NSA', 'SMX', 'SMF', 'NSS', 'SMR')

and State_Code = 'TRM'

Re: OR AND statement in Resident

Wed, 12 Mar 2014 15:16:39 GMT

Thanks everybody. I used brackets

topic Re: OR AND statement in Resident in QlikView

OR AND statement in Resident

Re: OR AND statement in Resident

Re: OR AND statement in Resident

Re: OR AND statement in Resident

Re: OR AND statement in Resident