topic Sumif question in QlikView

Sumif question

Thu, 06 Aug 2009 00:45:27 GMT

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

Sumif question

prieper — Thu, 06 Aug 2009 03:04:00 GMT

there is no attachment?

Sumif question

Thu, 06 Aug 2009 03:19:25 GMT

Sorry for that. I had some trouble uploading it.

Here it is.

Oliver

Sumif question

Thu, 06 Aug 2009 03:20:31 GMT

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

Oliver

Sumif question

Thu, 06 Aug 2009 04:47:06 GMT

Hope it works this time with the upload.

Oliver

Sumif question

Thu, 06 Aug 2009 04:49:22 GMT

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

Sumif question

Thu, 06 Aug 2009 05:23:36 GMT

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

Sumif question

Thu, 06 Aug 2009 14:10:38 GMT

Hi Oliver,

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

That´s all...

Rainer

Sumif question

Thu, 06 Aug 2009 19:21:32 GMT

Hi Rainer,

that was easy, thanks for the help,

Oliver