adding two corresponding column values and creating a new display column

[#1]

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

[sunny_talwar]

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

Load A,

        B,

        A+B as Sum,

        A*B as Times,

         A-B as Subtraction

FROM source;

[#3]

I did the same.

load

a

b

a+b as c

from source

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

[sunny_talwar]

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

[#5]

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.

[#6]

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)

[sunny_talwar]

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?

[#8]

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.

[sunny_talwar]

Try something like this:

LOAD a,

          b,

          c,

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

From Source;

[#10]

Thank You