Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-04-08 02:41 AM

sum aggr max per respondent over changing dimensions

Dear all,

What I am trying to do is find max values for 'BereikBruto' over several dimensions, however: per individual Respondent, where Respondents are unique in the lowest dimension of a Commercial, but have a multiple presence over a Date, Channel etc. wiht several values for 'BereiksBruto'.

I am looking for the highest value per Respondent over several dimensions and add these up.

Adding simply 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.

As shown below, the green value is correct (right column) but I can not get the formula correct to find my solution. Please advice.

example set.jpg

318 Views
0 Likes
0 Replies