topic script if statment in QlikView

script if statment

karensmith — Thu, 23 Jul 2009 20:19:53 GMT

Trying to use this statement in my load script. I would like to calculate value in script using two different prices * qty, rather doing calculation in chart object. I keep getting invalid expression errors.

duty code

Orig_Sales_Price

Req_qty

Local_Sales_prices

are all fields

if (DUTY_CODE = 'M', sum((ORIG_SALES_PRICE) * (REQ_QTY)), sum((LOCAL_SALES_PRICE) * (REQ_QTY))) as BKLGVALUE

Please advise if this possible. The syntax works in fine in chart object, but performance is affected.

script if statment

Thu, 23 Jul 2009 20:36:26 GMT

Hi,

When you use SUM in your load script you have to add a GROUP BY clause as well. I suppose this it what you are looking for:

if (DUTY_CODE = 'M', ORIG_SALES_PRICE * REQ_QTY, LOCAL_SALES_PRICE * REQ_QTY) as BKLGVALUE

This way you will have price*qty per row. Now you can SUM(BKLGVALUE) in your chart.

Regards

script if statment

karensmith — Fri, 24 Jul 2009 01:33:27 GMT

I'm loading my application from a qvd file? Group by works with QVD?

script if statment

Fri, 24 Jul 2009 13:51:52 GMT

Hi,

Yes, GROUP BY works with QVD, but you don't need it. You can simply use what I have given you above. Maybe I didn't communicate properly. GROUP BY was just some background information.

script if statment

karensmith — Sat, 25 Jul 2009 00:02:35 GMT

Thanks wernbrenk....I really appreciate your assistance.