topic Re: Aggr Sales Problem in QlikView

Aggr Sales Problem

Wed, 18 Mar 2015 18:28:53 GMT

Hi Qlik Community,

I have a unique use case, where I need to take the Aggregate of Margin. Below is the example

Region	Margin	Aggr Margin
A	-20	65
B	15	65
C	-30	65

In the example, Margin is simply taking Sum of sales - sum of costs. We want to create another column called aggr margin, which takes the absolute value of Margin and adds them up. In our example the correct # is 65 because (20+15+30).

I've attached the sample app.

Hope this made sense.

Thanks in advance.

Regards

Vishal

Re: Aggr Sales Problem

Wed, 18 Mar 2015 18:58:06 GMT

Ex: LOAD * INLINE

[ Region, Sales, Cost A, 100, 120 B, 40, 25 C, 300, 330 ];

Ex1:

Load Region ,

Sales ,

Cost,

Sales - Cost as Margin

Resident Ex;

DROP Table Ex;

join(Ex1)

Load sum(fAbs(Margin)) as aggrmargin

Resident Ex1;

Re: Aggr Sales Problem

maxgro — Wed, 18 Mar 2015 22:02:20 GMT

sum(total aggr(fabs(sum(Sales)-sum(Cost)),Region))

Re: Aggr Sales Problem

Fri, 20 Mar 2015 17:03:01 GMT

Somehow you both helped me find what i was looking for. Thanks Santosh and Massimo.