topic Re: Load Excel file and combining records in QlikView

Load Excel file and combining records

Fri, 19 Jun 2015 12:37:15 GMT

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 — Fri, 19 Jun 2015 15:52:03 GMT

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 — Fri, 19 Jun 2015 17:13:08 GMT

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