Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Master
Master
Author

Enclosed is my QV Doc