Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

How to combine 2 expression into 1 when TYPE=LOCAL PRODUCT is activate ?

Hi All

Below is my Expression of Land Cost 1

if(match(Currency_P,'SG'),

money(

(

Ceil(

LAND_COST_TDS_SGD

,0.5)

)

,CurrencyFormat_P),

money(

(

Ceil(

FOB_SGD_SUB

,0.5)

)

,CurrencyFormat_P)

)

Below is my Expression of Land Cost 2

if(match(Currency_P,'SG'),

money(

(

Ceil(

LAND_COST_TDS_SGD

,0.5)

)

,CurrencyFormat_P),

money(

(

Ceil(

FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS

,0.5)

)

,CurrencyFormat_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.

My imagine expression look some thing like below :-

if(match(Currency_P,'SG'),

money(

(

Ceil(

LAND_COST_TDS_SGD

,0.5)

)

,CurrencyFormat_P),

)

if(match(TYPE,'LOCAL PRODUCT'),

money(

(

Ceil(

FOB_SGD_SUB

,0.5)

)

,CurrencyFormat_P),

)

money(

(

Ceil(

FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS

,0.5)

)

,CurrencyFormat_P)

But it display nothing.

1 Reply
paulyeo11
Valued Contributor II

Re: How to combine 2 expression into 1 when TYPE=LOCAL PRODUCT is activate ?

Enclosed is my QV Doc

Community Browser