topic Re: Problem with set analysis with value from a field. in QlikView

Problem with set analysis with value from a field.

Anonymous — Thu, 26 Mar 2015 11:59:49 GMT

Hi,

I need to do a set analysis that sum the total of each customer for every row in a table.

Example:

DB:

CustomerID Year LineSalesAmount

A1 2014 100

A1 2015 300

A2 2012 500

A2 2014 700

A2 2015 300

I need to have:

CustomerID Year LineSalesAmount Total for each customer

A1 2014 100 400

A1 2015 300 400

A2 2012 500 1500

A2 2014 700 1500

A2 2015 300 1500

I try with set analysis and I read many post of community but I dont find how I can do this.

(I need the column 'Total for each customer ' to order the customers for their total turnover).

Please can you help me?

Thank you bery much.

Best regards.

MK_QSL — Thu, 26 Mar 2015 12:01:57 GMT

SUM(TOTAL <CustomerID> LineSalesAmount)

Anonymous — Thu, 26 Mar 2015 12:06:14 GMT

Thank you very much!

There was so simple...!

anbu1984 — Thu, 26 Mar 2015 12:07:22 GMT

Aggr(Sum(LineSalesAmount),CustomerID)

awhitfield — Thu, 26 Mar 2015 12:08:31 GMT

HI Giuseppe,

you could also try a pivot table then you don't get the customer total duplicated

Andy

See Attached

Anonymous — Thu, 26 Mar 2015 12:18:52 GMT

Thank you Andrew!

Anonymous — Thu, 26 Mar 2015 13:04:50 GMT

Tank you!