Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with getting the best rank for the year

Hi,

I have got two sets of data one containing Year & Activity & the other containing Contribution of student of various Schools in various methods.

Eg

Table1:

Year Activity

2006 ABC

2007 ABC

Table2:

School Student ContributionMethod Contribution YearA

A Jack Cash 100 2006

A Jack Kind 105 2006

A Jack Cash 110 2007

A Jack Card 150 2007

Similar data for other schools & other student as well

The two Year Variables can not be linked and have to be kept seperate .What I want as a solution is a table where when Activity ABC of Year1 is selected the highest contribution of Jack for the year is displayed

For example:

In Row 1 where the year is 2006 - Jack's highest contribution ie 105 is shown & in Row 2 where the year is 2007 - Jack's highest contribution oe 150 is shown

Please help ......

13 Replies
Not applicable
Author

Thanks Jochem - does help a bit as I get the desired results when I select the year. Can similar results be shown without selecting a year?

Not applicable
Author

Like this? Big Smile

Not applicable
Author

Thanks a lot - I guess I spent a lot of time trying to complicate a simple thing 🙂

Not applicable
Author

I think you were!! Embarrassed