topic Re: Top performance in QlikView https://community.qlik.com/t5/QlikView/Top-performance/m-p/484829#M685626 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P></BODY></HTML> Wed, 08 Jan 2014 22:45:42 GMT MayilVahanan 2014-01-08T22:45:42Z Top performance https://community.qlik.com/t5/QlikView/Top-performance/m-p/484827#M685624 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hello everyone,</SPAN></P><P><SPAN style="font-size: 10pt;">step 1 : from the table below i want to get for each field the best student in it&nbsp; (with the highest note) i.e : Math-&gt;Student1 and 4, History-&gt; Student2...</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 195px;"><TBODY><TR><TD height="15" width="65">Student</TD><TD width="65">field</TD><TD width="65">Note</TD></TR><TR><TD height="15">Student 1</TD><TD>Math</TD><TD align="right">9</TD></TR><TR><TD height="15">Student 1</TD><TD>HISTORY</TD><TD align="right">5</TD></TR><TR><TD height="15">Student 1</TD><TD>SPORT</TD><TD align="right">7</TD></TR><TR><TD height="15">Student 2</TD><TD>Math</TD><TD align="right">3</TD></TR><TR><TD height="15">Student 2</TD><TD>HISTORY</TD><TD align="right">10</TD></TR><TR><TD height="15">Student 2</TD><TD>SPORT</TD><TD align="right">8</TD></TR><TR><TD height="15">Student 3</TD><TD>Math</TD><TD align="right">6</TD></TR><TR><TD height="15">Student 3</TD><TD>HISTORY</TD><TD align="right">7</TD></TR><TR><TD height="15">Student 3</TD><TD>SPORT</TD><TD align="right">5</TD></TR><TR><TD height="15">Student 4</TD><TD class="xl63">Math</TD><TD align="right">9</TD></TR><TR><TD height="15">Student 4</TD><TD class="xl63">HISTORY</TD><TD align="right">8</TD></TR><TR><TD height="15">Student 4</TD><TD class="xl63">SPORT</TD><TD align="right">9</TD></TR></TBODY></TABLE><P></P><P>step 2 : by selecting a student from the list i want to get only fields in witch he is has the highest note comparing to his friends i.e when if i select Student 1 i should have only Math, Student 4-&gt; Math and SPORT...</P><P></P><P>any idea ?</P></BODY></HTML> Wed, 08 Jan 2014 22:28:13 GMT https://community.qlik.com/t5/QlikView/Top-performance/m-p/484827#M685624 mambi 2014-01-08T22:28:13Z Re: Top performance https://community.qlik.com/t5/QlikView/Top-performance/m-p/484828#M685625 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>You can hide columns of the straight table chart in presentation tab as needed.</P></BODY></HTML> Wed, 08 Jan 2014 22:40:44 GMT https://community.qlik.com/t5/QlikView/Top-performance/m-p/484828#M685625 swuehl 2014-01-08T22:40:44Z Re: Top performance https://community.qlik.com/t5/QlikView/Top-performance/m-p/484829#M685626 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P></BODY></HTML> Wed, 08 Jan 2014 22:45:42 GMT https://community.qlik.com/t5/QlikView/Top-performance/m-p/484829#M685626 MayilVahanan 2014-01-08T22:45:42Z Re: Top performance https://community.qlik.com/t5/QlikView/Top-performance/m-p/484830#M685627 <HTML><HEAD></HEAD><BODY><P>worked as i expected.</P><P>Thank's a lot.</P></BODY></HTML> Thu, 09 Jan 2014 08:48:35 GMT https://community.qlik.com/t5/QlikView/Top-performance/m-p/484830#M685627 mambi 2014-01-09T08:48:35Z