topic Aggr function? problem with total value in QlikView

Aggr function? problem with total value

Tue, 09 Feb 2010 13:41:39 GMT

Hi,

I'm trying to make a pivot chart where I can present the purchasing value for the recent period, multiplied with the quota between the quantity of the current period and the quantity of the recent period. I want this calculation to be made for every item (StockCode):

Sum({$<DeliveryYearActual={$(=DeliveryYearActual-1)}>}RowTotalSEK)

*(Sum(QtyRecieved)/

Sum({$<DeliveryYearActual={$(=DeliveryYearActual-1)}>}QtyRecieved))

Now this works fine on the item (StockCode) level, however the total value presented in the chart is not correct. I suspect it's because the total value does not calculate the value "per item". I guess I have to use som aggr function, but I cannot make it work.

Anyone knows what to do in order to solve this problem?

Best Regards,

Rickard

Aggr function? problem with total value

justinasp — Tue, 09 Feb 2010 14:40:13 GMT

I'm not sure, but you could try:

sum(total <StockCode> ... RowTotalSEK) etc.

Aggr function? problem with total value

johnw — Wed, 10 Feb 2010 01:48:11 GMT


rickard wrote:I suspect it's because the total value does not calculate the value "per item".

Right, the total value does not calculate the value "per item". By default, it applies the chart expression to the entire chart. If instead you want to sum up the rows, then properties -> expressions -> total mode -> sum of rows. Or am I misunderstanding the problem?