Reg : How to make an Expression.

sona_sa — Wed, 02 May 2012 16:47:58 GMT

Hi Friends,

I have two variable : i.e - for Total Collectable Amt and Total Reason Code Amt.

and Twelve Different - 12 Reason Code Amt.

i.e are following :

Reason_Land

Reason_LD Claim

Reason_Generation Claim

Reason_NOC

Reason_Projects

Reason_ROW

Reason_PE

Reason_Early RR

Reason_Others

Reason_Invoice / DCLR

Reason_RM

Reason_Fin Closure

vRCA = Sum(Reason_Land + Reason_LD Claim + Reason_Generation Claim + Reason_NOC + Reason_Projects + Reason_ROW + Reason_PE

+ Reason_Early RR + Reason_Others + Reason_Invoice / DCLR)

vCollectableAmt = Sum (Net Collectable)

Condition is :

1. If (vCollectableAmt > vRCA) and any one Reason Code Amt > 0 then replace that vCollectableAmt to that Reason Code Amt.

2. Else If Check (vCollectableAmt > vRCA) and Reason_RM_Amt = '0' and Reason_Fin_Closure_Amt = '0', then Add the difference of (vCollectableAmt - vRCA) in the behalf of max( Another 10 Reason Code Amt)

3.Else Check (vCollectableAmt > vRCA) and Reason_RM_Amt <> ' 0' and Reason_Fin_Closure_Amt <> ' 0' then Add the difference of (vCollectableAmt - vRCA) in the behalf of max( Another these two Reason_RM_Amt or Reason_Fin_Closure_Amt).

Thanks

Akumar

topic Reg : How to make an Expression. in QlikView

Reg : How to make an Expression.