topic How to establish horizontal linkage between data in QlikView https://community.qlik.com/t5/QlikView/How-to-establish-horizontal-linkage-between-data/m-p/1275918#M852161 <HTML><HEAD></HEAD><BODY><P>Hi Everybody,</P><P></P><P>This is my first post here, and I am not sure if it is the correct place to place my query.</P><P></P><P>I have loaded an excel in qlikview, like below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="427"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> Roll No</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> Name</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Year</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> Marks</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> ABC</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 2016</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 90</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> DEF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 2017</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 98</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 02</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> XYZ</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 2017</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 78</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>How can i fetch the name where Roll No is 01, year is 2017 with the highest marks for that roll no.? Please help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to establish horizontal linkage between data https://community.qlik.com/t5/QlikView/How-to-establish-horizontal-linkage-between-data/m-p/1275918#M852161 <HTML><HEAD></HEAD><BODY><P>Hi Everybody,</P><P></P><P>This is my first post here, and I am not sure if it is the correct place to place my query.</P><P></P><P>I have loaded an excel in qlikview, like below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="427"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> Roll No</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> Name</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Year</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> Marks</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> ABC</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 2016</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 90</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 01</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> DEF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 2017</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 98</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 02</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> XYZ</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 2017</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;"> 78</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>How can i fetch the name where Roll No is 01, year is 2017 with the highest marks for that roll no.? Please help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-establish-horizontal-linkage-between-data/m-p/1275918#M852161 2020-11-25T16:16:04Z Re: How to establish horizontal linkage between data https://community.qlik.com/t5/QlikView/How-to-establish-horizontal-linkage-between-data/m-p/1275919#M852162 <HTML><HEAD></HEAD><BODY><P>It is not the correct place.</P><P>The only thing that should be posted in Qlik DataMarket are topics about Qlik DataMarket.</P><P></P><P>Topic moved to QlikView forum.</P></BODY></HTML> Tue, 28 Feb 2017 09:16:31 GMT https://community.qlik.com/t5/QlikView/How-to-establish-horizontal-linkage-between-data/m-p/1275919#M852162 oknotsen 2017-02-28T09:16:31Z