topic Re: Aggregate excluded values in QlikView

Aggregate excluded values

Anonymous — Mon, 20 Jul 2015 18:04:32 GMT

Hello,

I am trying to sum sales for the time period that is not selected. I would like to sum the sales by week and display in a table with SKU number and the sum of sales. However, I am not getting a null output.

Any help would be greatly appreciated.

sum(

aggr(

sum({$<Week=E([Year Week]), SKU=P(SKU) >}Sales)

, SKU, Week)),

)

Re: Aggregate excluded values

sunny_talwar — Mon, 20 Jul 2015 18:09:49 GMT

Try this:

=Sum({$<Week=E([Year Week]), SKU=P(SKU) >} Aggr(Sum({$<Week=E([Year Week]), SKU=P(SKU) >}Sales), SKU, Week))

Re: Aggregate excluded values

Anonymous — Mon, 20 Jul 2015 18:15:43 GMT

That works! Thanks!

And if I wanted to take the standard deviation of the sales for each of the weeks, how would I go about writing the syntax?

Thanks!

Re: Aggregate excluded values

sunny_talwar — Mon, 20 Jul 2015 18:17:44 GMT

May be this:

=Stdev({$<Week=E([Year Week]), SKU=P(SKU) >} Aggr(Sum({$<Week=E([Year Week]), SKU=P(SKU) >}Sales), SKU, Week))