Aggregation level question

rrodriguesrr82 — Thu, 07 Jun 2018 17:21:54 GMT

Hi folks,

I have the following scenario:

Product	Units	NTS
Product A	10	1000
Product B	10	500

NTS is calculated by the following Formula: Unit Price * Units (There is table for product price in the model)
Consider that Product A and B have different Unit Prices.

I want to achieve the following result table:

Product	Units	NTS
Product	20	1500

I the table above, I have another dimension level that group Products by Brand. In my example, the brand name is Product.

However, by considering the NTS is not pre-calculated, I mean, NTS is actually an expression that multiplies Unit Price by Units, I'm getting the following NTS value:

Unit Price for Product A: 100;
Unit Price for Product B: 50;
Current Result: 20 * 150 = 3000.

I have tried to use AGGR, but I'm not so familiar with this function.

Do you have some clue?

Best,

Rubens

Re: Aggregation level question

Anonymous — Thu, 07 Jun 2018 17:34:43 GMT

Hello!

Try this:

=Sum(TOTAL AGGR(Sum([Unit Price]*Units), Product))

Re: Aggregation level question

sunny_talwar — Thu, 07 Jun 2018 17:39:16 GMT

or you can just use this

=Sum(Aggr(Sum(Unit Price * Units), Brand, Product))

topic Aggregation level question in QlikView

Aggregation level question

Re: Aggregation level question

Re: Aggregation level question