topic Re: Sumproduct problem in QlikView

Sumproduct problem

Thu, 30 Jul 2015 13:08:27 GMT

I need to multiply a monthly volume with a monthly rate, for a certain product (X), and then sum it per quarter.

Variables as per below:

VOLUME

RATE

PRODUCT

MONTH

QUARTER

Any ideas?

Rgds,

Olle

Thu, 30 Jul 2015 13:09:42 GMT

Clarification: First I need to sum volume*rate per month.

Then sum the results by quarter

sunny_talwar — Thu, 30 Jul 2015 13:15:37 GMT

Try this may be if Quarter is your dimension:

Sum(Aggr(Sum(Volumne) * Sum(Rate), Month))

robert_mika — Thu, 30 Jul 2015 13:16:17 GMT

Could you post your data or qvw?

Thu, 30 Jul 2015 13:24:17 GMT

Hi Sunny,

tried the below, with Quarter as dimension.

Got zero results unfortunately. Maybe I've put the set analysis bracket incorrectly?

Sum(Aggr(Sum({<Type= {'X'}>}Volume) * Sum(Rate), Month))

Thu, 30 Jul 2015 13:26:04 GMT

Just realized one thing.

The Rate is also a sum.

So need to sum up the rate per month and product=X first as well.

sunny_talwar — Thu, 30 Jul 2015 13:27:06 GMT

May be this:

Sum({<Type= {'X'}>}Aggr(Sum({<Type= {'X'}>}Volume) * Sum({<Type= {'X'}>}Rate), Month))