topic If Logic in script in QlikView

If Logic in script

nehasaxena — Tue, 11 Sep 2018 11:15:52 GMT

Hi All,

I am trying to move 1 logic from front end to back end.

Front end Logic -

Count(Distinct{

<T_Time_ID ={">=7"},Policy_Type_Flag={2},Status_Flag={2},PaymentGroup={2,3},OutstandingBalance_Flag={1}>

<T_Time_ID ={">=7"},Policy_Type_Flag={2},Status_Flag={2},PaymentGroup={1,4}>

} P_Q_ID)

Back end -

If(T_Time_ID >=7,

If(Policy_Type_Flag=2,

If(Status_Flag=2,If(PaymentGroup=2 OR PaymentGroup=3,IF(OutstandingBalance_Flag= 1,1,0),0),0),0),0),

IF(T_Time_ID >=7,

If(Policy_Type_Flag=2,

If(Status_Flag=2,If(PaymentGroup=1 OR PaymentGroup=4,1,0),0),0),0) as CurrentFlag

I am not sure how to put the condition in backend as 1 condition required outstanding flag and 1 not.

Thanks

Neha

Re: If Logic in script

YoussefBelloum — Tue, 11 Sep 2018 11:41:11 GMT

Hi,

I would've tried this:

if( (T_Time_ID >= 7 and Policy_Type_Flag = 2 and Status_Flag = 2 and Match(PaymentGroup,2,3) and OutstandingBalance_Flag = 1) OR (T_Time_ID >=7 and Policy_Type_Flag = 2 and Status_Flag = 2 and Match(PaymentGroup,1,4) ), 1, 0) as CurrentFlag

Re: If Logic in script

Anonymous — Tue, 11 Sep 2018 11:57:00 GMT

try this:

If((T_Time_ID >=7) and (Policy_Type_Flag=2) and (Status_Flag=2),

If (((PaymentGroup=2) OR (PaymentGroup=3)) and (OutstandingBalance_Flag= 1),1,

If ((PaymentGroup=1) OR (PaymentGroup=4),1 ,0))) as CurrentFlag

Re: If Logic in script

nehasaxena — Mon, 24 Sep 2018 06:18:19 GMT

Hi,

This works fine, Thanks.

Neha