How to establish horizontal linkage between data

[#1]

Hi Everybody,

This is my first post here, and I am not sure if it is the correct place to place my query.

I have loaded an excel in qlikview, like below:

Roll No	Name	Year	Marks
01	ABC	2016	90
01	DEF	2017	98
02	XYZ	2017	78

How can i fetch the name where Roll No is 01, year is 2017 with the highest marks for that roll no.? Please help.

[oknotsen]

It is not the correct place.

The only thing that should be posted in Qlik DataMarket are topics about Qlik DataMarket.

Topic moved to QlikView forum.