How to make my expression simplify ?

paulyeo11 — Tue, 08 Jul 2014 05:23:19 GMT

Hi All

I have a expression which is working fine , and look for solution to simpliy it. in case some one have good idea pls share.

(

match(Currency_P,'SG') and (match (BRAND_P,'IBH')),

(AFTER_DISCOUNT*RATE_IBH*T_IBH/1),

(

match(Currency_P,'SG') and (match (BRAND_P,'BECKHOFF')),

(AFTER_DISCOUNT*RATE_BK*T_BK/1),

(

match(Currency_P,'SG') and (match (BRAND_P,'PHOENIX')),

(AFTER_DISCOUNT*RATE_PH*T_PH/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_GE*T_GE/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'PHOENIX')),

(AFTER_DISCOUNT*RATE_PH*T_PH/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'TOP')),

(AFTER_DISCOUNT*RATE_TOP*T_TOP/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'MITSUBISHI')),

(AFTER_DISCOUNT*RATE_MI*T_MI/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'REDLION')),

(AFTER_DISCOUNT*RATE_RED*T_RED/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'SECOMEA')),

(AFTER_DISCOUNT*RATE_SEC*T_SEC/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'KEB')),

(AFTER_DISCOUNT*RATE_KEB*T_KEB/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'KINCO')),

(AFTER_DISCOUNT*RATE_KI*T_KI/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'HMS')),

(AFTER_DISCOUNT*RATE_HMS*T_HMS/1),

if(match(Currency_P,'SG') and (match (BRAND_P,'HAKKO')),

(AFTER_DISCOUNT*RATE_HA*T_HA/1),

(

match(Currency_P,'MY') and (match (BRAND_P,'IBH')),

(AFTER_DISCOUNT*RATE_IBH*RATE_MY*T_IBH*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_GE*RATE_MY*T_GE*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'PHOENIX')),

(AFTER_DISCOUNT*RATE_PH*RATE_MY*T_PH*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'BECKHOFF')),

(AFTER_DISCOUNT*RATE_BK*RATE_MY*T_BK*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'KEB')),

(AFTER_DISCOUNT*RATE_KEB*RATE_MY*T_KEB*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'HMS')),

(AFTER_DISCOUNT*RATE_HMS*RATE_MY*T_HMS*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'MITSUBISHI')),

(AFTER_DISCOUNT*RATE_MI*RATE_MY*T_MI*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'REDLION')),

(AFTER_DISCOUNT*RATE_RED*RATE_MY*T_RED*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'SECOMEA')),

(AFTER_DISCOUNT*RATE_SEC*RATE_MY*T_SEC*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'HAKKO')),

(AFTER_DISCOUNT*RATE_HA*RATE_MY*T_HA*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

if(match(Currency_P,'MY') and (match (BRAND_P,'TOP')),

(AFTER_DISCOUNT*RATE_TOP*RATE_MY*T_TOP*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

(

match(Currency_P,'THAI') and (match (BRAND_P,'IBH')),

(AFTER_DISCOUNT*RATE_IBH*RATE_THAI*T_IBH*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_GE*RATE_THAI*T_GE*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'PHOENIX')),

(AFTER_DISCOUNT*RATE_PH*RATE_THAI*T_PH*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'BECKHOFF')),

(AFTER_DISCOUNT*RATE_BK*RATE_THAI*T_BK*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'TOP')),

(AFTER_DISCOUNT*RATE_TOP*RATE_THAI*T_TOP*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'KINCO')),

(AFTER_DISCOUNT*RATE_KI*RATE_THAI*T_KI*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'MITSUBISHI')),

(AFTER_DISCOUNT*RATE_MI*RATE_THAI*T_MI*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'SECOMEA')),

(AFTER_DISCOUNT*RATE_SEC*RATE_THAI*T_SEC*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'KEB')),

(AFTER_DISCOUNT*RATE_KEB*RATE_THAI*T_KEB*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'HMS')),

(AFTER_DISCOUNT*RATE_HMS*RATE_THAI*T_HMS*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'HAKKO')),

(AFTER_DISCOUNT*RATE_HA*RATE_THAI*T_HA*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'THAI') and (match (BRAND_P,'REDLION')),

(AFTER_DISCOUNT*RATE_RED*RATE_THAI*T_RED*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

if(match(Currency_P,'INDO') and (match (BRAND_P,'IBH')),

(AFTER_DISCOUNT*RATE_IBH*RATE_ID*T_IBH*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'BECKHOFF')),

(AFTER_DISCOUNT*RATE_BK*RATE_ID*T_BK*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'PHOENIX')),

(AFTER_DISCOUNT*RATE_PH*RATE_ID*T_PH*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'HAKKO')),

(AFTER_DISCOUNT*RATE_HA*RATE_ID*T_HA*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'MITSUBISHI')),

(AFTER_DISCOUNT*RATE_MI*RATE_ID*T_MI*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'HMS')),

(AFTER_DISCOUNT*RATE_HMS*RATE_ID*T_HMS*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'KEB')),

(AFTER_DISCOUNT*RATE_KEB*RATE_ID*T_KEB*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'SECOMEA')),

(AFTER_DISCOUNT*RATE_SEC*RATE_ID*T_SEC*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'KINCO')),

(AFTER_DISCOUNT*RATE_KI*RATE_ID*T_KI*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'TOP')),

(AFTER_DISCOUNT*RATE_TOP*RATE_ID*T_TOP*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'REDLION')),

(AFTER_DISCOUNT*RATE_RED*RATE_ID*T_RED*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

if(match(Currency_P,'INDO') and (match (BRAND_P,'GE')),

(AFTER_DISCOUNT*RATE_GE*RATE_ID*T_GE*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID)

)

)))

))

))))))))

)

))

)

))))))))))))))))))))))))))))

Re: How to make my expression simplify ?

paulyeo11 — Tue, 08 Jul 2014 05:56:35 GMT

Hi Ram

Can you give me some example . Do I know what you mean.

Paul

Sent from Samsung Mobile

Re: How to make my expression simplify ?

paulyeo11 — Tue, 08 Jul 2014 05:57:47 GMT

Hi Ana

I unable to do it at script level . Because user need to Chamge the exchange rate and mark up.

Paul

Sent from Samsung Mobile

topic Re: How to make my expression simplify ? in QlikView

How to make my expression simplify ?

Re: How to make my expression simplify ?

Re: How to make my expression simplify ?

Re: How to make my expression simplify ?

Re: How to make my expression simplify ?

Re: How to make my expression simplify ?