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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

My QV Doc