topic How to add two numerical fields together in QlikView

How to add two numerical fields together

Mon, 03 Nov 2014 14:01:41 GMT

I have Software amount and Services amount -- want to create a new field that adds the number values together across each row. A total deal value field.

How is this done?

Re: How to add two numerical fields together

anbu1984 — Mon, 03 Nov 2014 14:04:45 GMT

In Script,

Load

SoftwareAmount,

ServicesAmount,

SoftwareAmount + ServicesAmount As DealValue

From Table

Re: How to add two numerical fields together

jerem1234 — Mon, 03 Nov 2014 14:04:57 GMT

something like:

Load .....,

SoftwareField+ServicesField as DealField,

...

FROM ...

Hope this helps!

Re: How to add two numerical fields together

Anonymous — Mon, 03 Nov 2014 14:11:34 GMT

Hi,

In your script in the table where you get your original fields Software amount and Services amount add a new field DealValue.

You can keep Software amount and Services amount if needed otherwise you can leave them.

Example:

FinalTable:

Load

SoftwareAmount, // if you don't need this field anymore just forget this line

ServicesAmount, // if you don't need this field anymore just forget this line

(SoftwareAmount + ServicesAmount) as DealValue

From

YourTable