Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

How to make my expression simplify ?

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.

if

(

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

(AFTER_DISCOUNT*RATE_IBH*T_IBH/1),

if

(

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

(AFTER_DISCOUNT*RATE_BK*T_BK/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,'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),

if

(

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),

if

(

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)

)

)

)))

))

))))))))

)

))

)

)

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

5 Replies
paulyeo11
Valued Contributor II

Re: How to make my expression simplify ?

my Qv Doc

Not applicable

Re: How to make my expression simplify ?

you should use the first condition in a simple if and you can combine all other conditions using Pick and Match.

Re: How to make my expression simplify ?

You can apply this condition in the Backend means in script level and then use the fields in the charts is the best way because if you use if condition with nested if condition will effect the performance of yours chart it will get slow. For doing this you have to use put this condition in script levels.

paulyeo11
Valued Contributor II

Re: How to make my expression simplify ?

Hi Ram

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

Paul

Sent from Samsung Mobile

paulyeo11
Valued Contributor II

Re: How to make my expression simplify ?

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

Community Browser