Adding Two Statements Together! (HELP)

Fri, 15 Apr 2011 03:46:41 GMT

HI GUYS, THIS IS BASICALLY ADDING 2 IF STATEMENTS TOGETHER, I'M NOT SURE HOW TO GO ABOUT DOING THIS, PLEASE HELP! THANKS!

I'VE ADDED THE QLIKVIEW FILE INSIDE AS WELL.

THANK YOU! =D

Adding Two Statements Together! (HELP)

erichshiino — Fri, 15 Apr 2011 05:14:01 GMT

Hi,

I just replaced Duty and Tax by your if statements.

The result is:

if(match(Seg,'BP'),money(sum(Ceil(([Price(Euros)]*if([PRODUCT_TYPE]<>'TwinCAT', Tax,1)*if([PRODUCT_TYPE]<>'TwinCAT', Duty,1)*TRANSPORT*Rate)/BP,0.5)),CurrencyFormat),
money(sum(Ceil((PRICE*EURO*DISCOUNT_FACTOR*1)/SUB*if([PRODUCT_TYPE]<>'TwinCAT', Tax,1)*if([PRODUCT_TYPE]<>'TwinCAT', Duty,1)*TRANSPORT*Rate/Markup,0.5)),CurrencyFormat))

So,

Instead of Duty, you can use if( field='Value', 1, Duty)

in an expression:

1 * Duty * 150

became

1 * if( field='Value', 1, Duty) * 150

Rgds,

topic Adding Two Statements Together! (HELP) in QlikView

Adding Two Statements Together! (HELP)

Adding Two Statements Together! (HELP)