Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to insert If SOURCE = TDSS , US_Cust=USD use 1.3 rate , If SOURCE = TDSKL , US_Cust=USD use 4.3 rate to my expression ?

Hi All

My below exlow expression work fine :-

'S$ ' &Num(

sum(If ( US_Cust='USD', 1.3,If ( US_Cust='MYR', 1/3,if(US_Cust='EU',1.5, 1))) * curren+days3+days6+days9+above12)

,'###,##0.00')

I need to add below condition on to the above expression :-

If SOURCE = TDSS , US_Cust=USD use 1.3 rate

If SOURCE = TDSKL , US_Cust=USD use 4.3 rate

Can some one advise me how to insert the above condition ?

When user click on SOURCE = TDSKL , The amount should display 233,613.74

When user click on SOURCE = TDSS , The amount should display 18,662

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: How to insert If SOURCE = TDSS , US_Cust=USD use 1.3 rate , If SOURCE = TDSKL , US_Cust=USD use 4.3 rate to my expression ?

my QVW

Community Browser