Discussion board where members can get started with QlikView.
I need to make a sum for different options.
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?
Go to Solution.
Here u Go.. Hope to Help!!!
Please provide example of the input data.
Here you go
What output do u want??? no. of products deliverd/Not delivered?? do u have any field regarding that??
Where do you get the number ordered from in there?
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.