Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to sum max values through aggregating dimensions?

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.

3 Replies

Re: How to sum max values through aggregating dimensions?

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

pokassov
Valued Contributor

Re: How to sum max values through aggregating dimensions?

Hi!

It's something like this:

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

Not applicable

Re: How to sum max values through aggregating dimensions?

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.

example set.jpg

Community Browser