topic Re: adding two corresponding column values and creating a new display column in QlikView

adding two corresponding column values and creating a new display column

Thu, 10 Dec 2015 16:06:37 GMT

Hii,

I am very new to qlikview. Its my 2nd day. I loaded two columns but now need to the corresponding values and then make a new column to display those calculated values. Please help

thanks in advance

Re: adding two corresponding column values and creating a new display column

sunny_talwar — Thu, 10 Dec 2015 16:13:52 GMT

Not sure what you mean, but may be something like this:

Load A,

A+B as Sum,

A*B as Times,

A-B as Subtraction

FROM source;

Re: adding two corresponding column values and creating a new display column

Thu, 10 Dec 2015 16:23:57 GMT

I did the same.

load

a+b as c

from source

but doesn't seem to be working for me. thanks for reply though.

Re: adding two corresponding column values and creating a new display column

sunny_talwar — Thu, 10 Dec 2015 16:48:41 GMT

I don't see why it should not work. Do you have a sample where you can show it doesn't work?

Re: adding two corresponding column values and creating a new display column

Thu, 10 Dec 2015 17:03:47 GMT

It is working for simple data, but I am working on more complicated data Such as a company has a database and the columns are not properly populated, when I try to add the two columns it doesn't give the correct answer.

Re: adding two corresponding column values and creating a new display column

Thu, 10 Dec 2015 17:13:52 GMT

and can you please help me if I have to use three columns in an arithmetic expression such as i want to do

a+b+(c+d)

Re: adding two corresponding column values and creating a new display column

sunny_talwar — Thu, 10 Dec 2015 17:33:20 GMT

anita sain wrote:

and can you please help me if I have to use three columns in an arithmetic expression such as i want to do

a+b+(c+d)

Not sure I understand. What do you mean?

Re: adding two corresponding column values and creating a new display column

Thu, 10 Dec 2015 17:43:48 GMT

for example I have three columns a, b and c

and I need to make another column which should be -1*(a+b)+c

then How would I do it.

Because if I Put Brackets sign such as () it shows error.

hope I am clear now.

Re: adding two corresponding column values and creating a new display column

sunny_talwar — Thu, 10 Dec 2015 18:03:17 GMT

Try something like this:

LOAD a,

((-1 * (a+b)) + c) as d

From Source;

Re: adding two corresponding column values and creating a new display column

Thu, 10 Dec 2015 18:15:14 GMT

Thank You

Re: adding two corresponding column values and creating a new display column

sunny_talwar — Thu, 10 Dec 2015 18:20:39 GMT

Not a problem