Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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.
Would be happy if you can provide few lines of sample or dummy data... This would make easy to understand your actual requirements..
It's something like this:
1. sum(aggr(max(respondents), your_dimension))
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.