topic Re: Sum if in QlikView

Sum if

Thu, 27 Sep 2012 11:22:21 GMT

I need to make a sum for different options.

Example:

The order for account A is 10. We have failed to deliver 1, which is marked as "failed". (in the tabel 2 rows, commom dimensions are accountnr and ordernr)

The order for account B is 100. We have delivered all.

I need the following result:

Ordered Delivered Not delivered

Account A 10 9 1

Account B 100 100 0

How can I proceed? Best to use Rowno or Recno? Or something else?

Thanks!

Re: Sum if

Jason_Michaelides — Thu, 27 Sep 2012 11:56:18 GMT

Please provide example of the input data.

Re: Sum if

Thu, 27 Sep 2012 12:04:48 GMT

Customer	Ordered/ delivered	Article	Date	Amount
Customer A	Ordered	105	26-sep-12	1
Customer A	Not delivered	105	26-sep-12	-1
Customer B	Ordered	105	26-sep-12	1
Customer B	Not delivered	105	26-sep-12	-1
Customer C	Ordered	105	26-sep-12	1
Customer C	Not delivered	105	26-sep-12	-1
Customer D	Ordered	105	26-sep-12	1
Customer D	Not delivered	105	26-sep-12	-1
Customer E	Ordered	105	26-sep-12	1
Customer E	Not delivered	105	26-sep-12	-1
Customer F	Ordered	105	26-sep-12	1
Customer F	Not delivered	105	26-sep-12	-1
Customer G	Ordered	105	26-sep-12	1
Customer G	Not delivered	105	26-sep-12	-1
Customer H	Ordered	105	26-sep-12	1
Customer H	Not delivered	105	26-sep-12	-1

Re: Sum if

Thu, 27 Sep 2012 12:06:08 GMT

Here you go

Re: Sum if

rajni_batra — Thu, 27 Sep 2012 12:20:33 GMT

What output do u want??? no. of products deliverd/Not delivered?? do u have any field regarding that??

Re: Sum if

Jason_Michaelides — Thu, 27 Sep 2012 12:20:50 GMT

Where do you get the number ordered from in there?

Re: Sum if

Thu, 27 Sep 2012 12:26:14 GMT

The output I need is in the following format:

Customer Amount ordered Amount not delivered

Customer A 1 -1

Customer B 1 -1

Customer C 1 -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

Re: Sum if

Thu, 27 Sep 2012 12:26:28 GMT

The output I need is in the following format:

Customer Amount ordered Amount not delivered

Customer A 1 -1

Customer B 1 -1

Customer C 1 -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

Re: Sum if

Thu, 27 Sep 2012 12:26:49 GMT

The output I need is in the following format:

Customer Amount ordered Amount not delivered

Customer A 1 -1

Customer B 1 -1

Customer C 1 -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

Re: Sum if

Thu, 27 Sep 2012 12:27:49 GMT

The output I need is in the following format:

Customer Amount ordered Amount not delivered

Customer A 1 -1

Customer B 1 -1

Customer C 1 -1

So the second line per customer needs to be added to the first line. In this example it's only 2 lines per customer, but it can be more.

Re: Sum if

Thu, 27 Sep 2012 12:29:23 GMT

Sorry, it's maybe confusing. Both examples are not the same.

Re: Sum if

Thu, 27 Sep 2012 12:30:49 GMT

Sorry, it's maybe confusing. Both examples are not the same.

Re: Sum if

rajni_batra — Thu, 27 Sep 2012 12:31:11 GMT

Here u Go.. Hope to Help!!!

Re: Sum if

Thu, 27 Sep 2012 12:52:36 GMT

Perfect! thanks!

Re: Sum if

Thu, 27 Sep 2012 12:56:01 GMT

Perfect! thanks!