Load Excel file and combining records

[#1]

Hi,

I am quit new at QlikSense and I am struggling with a grouping issue.

My data is in Excel and I need to joing some records with identical values.

On each item where OrderID and part are equal I need to make the sum of Qty and value.

Below you can see in the first part the Excle sheet and in the second part youy see the result I need.

Can anybody assist?

[sunny_talwar]

Try this:

Table:

LOAD OrderID,

          Part,

          Qty,

          Value,

          Customer

FROM yourSoruce;

Table1:

NoConcatenate

LOAD OrderID,

          Part,

          Sum(Qty) as Qty,

          Sum(Value) as Value,

          Customer

Resident Table

Group By OrderID, Part, Customer;

Drop Table Table;

[Gysbert_Wassenaar]

Create a Table object with OrderID, Part and Customers as dimensions and add two measures: sum(Qty) and sum(Value).