Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

How to add 1 more condition to my expression

Hi All

I have one expression is working fine , only have 1 condition :-

if(match(Currency_P,'ID'),

i like to make additional condition on :-

if(match(Currency_P,'ID'),

My Org Expression is below :-

if(match(Currency_P,'SG'),

money(

(

Ceil(

AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU

,0.5)

)

,CurrencyFormat_P),

money(

(

Ceil(

floor(ceil(AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU/MARKUP_SUB*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,.5), .1)

,0.5)

)

,CurrencyFormat_P)

)

I modify the below :-

if(match(Currency_P,'SG'),

money(

(

Ceil(

AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU

,0.5)

),CurrencyFormat_P),

if(match(Currency_P,'ID'),

money(

(

Ceil(

floor(ceil(AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU/MARKUP_SUB*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,.5), .1)

,0.5)

)

),CurrencyFormat_P)

)

Above is not working.

Hope some one can help me.

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: How to add 1 more condition to my expression

My QV Doc

Community Browser