topic Re: How to sum max values through aggregating dimensions? in QlikView

How to sum max values through aggregating dimensions?

Thu, 02 Apr 2015 16:44:15 GMT

Dear friends,

I would like to find out how to:

1. sum max values of 'respondents' per dimension

2. re-calculate the sum of max values of respondents over higher dimensions

Respondents values can be multiple over higher / aggregating dimensions.

Example:

a. 40 respondents have contact with a commercial (lowest dimension), so max value per respondent will be the current value

b. On a daily basis (i.e. date) 20 spots are broadcasted and respondents have contact with several out of 20 ('random')

c. I would like to display in aggregated total the sum of the max value of all individual respondents who watched one or more spots that day

The value is called 'GrossReach'.

Higher dimensions are for example Channel, SalesHouse, MediaType.

I am having trouble to define properly with sum, max and aggr.

Anybody any ideas?

Kind regards, Ed.

Re: How to sum max values through aggregating dimensions?

MK_QSL — Thu, 02 Apr 2015 16:59:30 GMT

Would be happy if you can provide few lines of sample or dummy data... This would make easy to understand your actual requirements..

Re: How to sum max values through aggregating dimensions?

pokassov — Thu, 02 Apr 2015 17:03:09 GMT

Hi!

It's something like this:

1. sum(aggr(max(respondents), your_dimension))

Re: How to sum max values through aggregating dimensions?

Fri, 03 Apr 2015 14:27:00 GMT

Hi Manish, sorry for some delay this Good Friday. What I am trying to do is find max values for 'BereikBruto', per individual Respondent over several dimensions.

Adding all 'BereikBruto' (meaning gross reach) values up is displayed in sum(BereikBruto). What I need to esthablish is a figure around 13mio in total for 'net reach' in total.

Respondents are represented multiple times over dimensions larger than spot-level (tv commercial), so over those dimensions I just need to add up de max value per individual respondent.