topic How to combine 2 expression into 1 when TYPE=LOCAL PRODUCT is activate ? in QlikView https://community.qlik.com/t5/QlikView/How-to-combine-2-expression-into-1-when-TYPE-LOCAL-PRODUCT-is/m-p/646873#M542397 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>Below is my Expression of Land Cost 1</P><P></P><P></P><P>if(match(Currency_P,'SG'),</P><P>money(</P><P>(</P><P>Ceil(</P><P>LAND_COST_TDS_SGD</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P)</P><P>)</P><P></P><P></P><P></P><P></P><P>Below is my Expression of Land Cost 2</P><P></P><P></P><P></P><P></P><P>if(match(Currency_P,'SG'),</P><P>money(</P><P>(</P><P>Ceil(</P><P>LAND_COST_TDS_SGD</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P)</P><P>)</P><P></P><P></P><P></P><P></P><P>Both are working fine . Now my task is to make 2 expression combine into 1 ( Land Cost 3 ) when user press TYPE = LOCAL PRODUCT.</P><P></P><P></P><P>My imagine expression look some thing like below :-</P><P></P><P></P><P>if(match(Currency_P,'SG'),</P><P></P><P></P><P>money(</P><P>(</P><P>Ceil(</P><P>LAND_COST_TDS_SGD</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>)</P><P></P><P></P><P>if(match(TYPE,'LOCAL PRODUCT'),</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>)</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P)</P><P></P><P></P><P></P><P></P><P>But it display nothing.</P></BODY></HTML> Tue, 10 Jun 2014 02:16:11 GMT paulyeo11 2014-06-10T02:16:11Z How to combine 2 expression into 1 when TYPE=LOCAL PRODUCT is activate ? https://community.qlik.com/t5/QlikView/How-to-combine-2-expression-into-1-when-TYPE-LOCAL-PRODUCT-is/m-p/646873#M542397 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>Below is my Expression of Land Cost 1</P><P></P><P></P><P>if(match(Currency_P,'SG'),</P><P>money(</P><P>(</P><P>Ceil(</P><P>LAND_COST_TDS_SGD</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P)</P><P>)</P><P></P><P></P><P></P><P></P><P>Below is my Expression of Land Cost 2</P><P></P><P></P><P></P><P></P><P>if(match(Currency_P,'SG'),</P><P>money(</P><P>(</P><P>Ceil(</P><P>LAND_COST_TDS_SGD</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P)</P><P>)</P><P></P><P></P><P></P><P></P><P>Both are working fine . Now my task is to make 2 expression combine into 1 ( Land Cost 3 ) when user press TYPE = LOCAL PRODUCT.</P><P></P><P></P><P>My imagine expression look some thing like below :-</P><P></P><P></P><P>if(match(Currency_P,'SG'),</P><P></P><P></P><P>money(</P><P>(</P><P>Ceil(</P><P>LAND_COST_TDS_SGD</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>)</P><P></P><P></P><P>if(match(TYPE,'LOCAL PRODUCT'),</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P),</P><P>)</P><P>money(</P><P>(</P><P>Ceil(</P><P>FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS</P><P>,0.5)</P><P>)</P><P>,CurrencyFormat_P)</P><P></P><P></P><P></P><P></P><P>But it display nothing.</P></BODY></HTML> Tue, 10 Jun 2014 02:16:11 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-expression-into-1-when-TYPE-LOCAL-PRODUCT-is/m-p/646873#M542397 paulyeo11 2014-06-10T02:16:11Z Re: How to combine 2 expression into 1 when TYPE=LOCAL PRODUCT is activate ? https://community.qlik.com/t5/QlikView/How-to-combine-2-expression-into-1-when-TYPE-LOCAL-PRODUCT-is/m-p/646874#M542398 <HTML><HEAD></HEAD><BODY><P>Enclosed is my QV Doc</P></BODY></HTML> Tue, 10 Jun 2014 02:17:49 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-expression-into-1-when-TYPE-LOCAL-PRODUCT-is/m-p/646874#M542398 paulyeo11 2014-06-10T02:17:49Z