Sumif question

[#1]

Hello All,

hope somebody can help me with this:

I have a table with the following columns: Customer, Type of Operation and Value.

I want to create a table with the following columns: Customer, Type A Operation, Type B Operation.

Type A and B are the different type of operations which can appear in the column Type of Operation in the original table. The value of of that field should be the sum of value by customer, if Type of Operation is either A or B. I tried it with "if", but it doesn't work. Please have a look at the attached example.

Thanks in advance,

Oliver

[prieper]

there is no attachment?

[#3]

Sorry for that. I had some trouble uploading it.

Here it is.

Oliver

[#4]

Still doesn't work with the upload. Will try it from home later.

Oliver

[#5]

Hope it works this time with the upload.

Oliver

[#6]

Sorry for all these emails, but I can not upload any files. Not from work or home, different computers as well.

[#7]

OK, the file is under my profile and called test. Sorry for all those emails and confusion, but for some reason I was not able to upload it.

Thanks in advance,

Oliver

[#8 · Accepted solution]

Hi Oliver,

just let QlikView know that you need the SUM of your values.

That´s all...

Rainer

[#9]

Hi Rainer,

that was easy, thanks for the help,

Oliver