Group By, Sum

Wed, 02 Jun 2010 10:23:42 GMT

Hi,

Appologies for the simple (I think) question. And i cant find an answer from the forum so far.

I have a number of fields (6) of which one is a customer number, another is an outstanding balance field. Now one customer number can have several outstanding balances. What i would like is to have the customer number appear only once, with the total of all the outstanding balances showing rather than duplicate customer numbers.

Am i right in thinking that i should be using the Group By or the Sum function?

This is how my script looks at the moment:

LOAD

Absolute_Balance

Dunning_Level

Dunning_Procedure

Last_Payment_Received_Date

FROM

WHERE

Many thanks.

EXISTS (BP) ; (qvd )

Group By, Sum

Wed, 02 Jun 2010 10:41:58 GMT

Hi,

first try to create a pivottable and see if this is what you are looking for.

Good luck!

Rainer

topic Group By, Sum in QlikView

Group By, Sum

Group By, Sum