topic Problem with max values in QlikView https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679665#M475047 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm struggeling for some time now and can't find the solution.</P><P></P><P>I have a record set as stated below:</P><P></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 410px; height: 92px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PersonName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EducationLevel</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EducationLevelDescription</STRONG></TH></TR><TR><TD style="padding: 2px;">Arno</TD><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">HBO</TD></TR><TR><TD style="padding: 2px;">Arno</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">MBO</TD></TR><TR><TD style="padding: 2px;">Michael</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">VMBO</TD></TR><TR><TD style="padding: 2px;">Michael</TD><TD style="padding: 2px;">9</TD><TD style="padding: 2px;"><P>HBO</P></TD></TR></TBODY></TABLE><P></P><P>I have two objectives in my model. In the dashboard tab I do want to show the Personnames with highest education level descriptions. In the detail tab I want the complete history of all the employees. </P><P><BR />I really think this should be easy, so it's a quite frustrating <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>How do I solve this? Thx!</P></BODY></HTML> Thu, 14 Aug 2014 09:35:06 GMT 2014-08-14T09:35:06Z Problem with max values https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679665#M475047 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm struggeling for some time now and can't find the solution.</P><P></P><P>I have a record set as stated below:</P><P></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid rgb(0, 0, 0); width: 410px; height: 92px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PersonName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EducationLevel</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>EducationLevelDescription</STRONG></TH></TR><TR><TD style="padding: 2px;">Arno</TD><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">HBO</TD></TR><TR><TD style="padding: 2px;">Arno</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">MBO</TD></TR><TR><TD style="padding: 2px;">Michael</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">VMBO</TD></TR><TR><TD style="padding: 2px;">Michael</TD><TD style="padding: 2px;">9</TD><TD style="padding: 2px;"><P>HBO</P></TD></TR></TBODY></TABLE><P></P><P>I have two objectives in my model. In the dashboard tab I do want to show the Personnames with highest education level descriptions. In the detail tab I want the complete history of all the employees. </P><P><BR />I really think this should be easy, so it's a quite frustrating <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>How do I solve this? Thx!</P></BODY></HTML> Thu, 14 Aug 2014 09:35:06 GMT https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679665#M475047 2014-08-14T09:35:06Z Re: Problem with max values https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679666#M475048 <HTML><HEAD></HEAD><BODY><P>Create a straight Table</P><P>Dimension</P><P>PersonName</P><P></P><P>Expression</P><P>FirstSortedValue(EducationLevelDescription,-EducationLevel)</P></BODY></HTML> Thu, 14 Aug 2014 09:36:46 GMT https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679666#M475048 2014-08-14T09:36:46Z Re: Problem with max values https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679667#M475049 <HTML><HEAD></HEAD><BODY><P>Thanks! </P><P></P><P>So close... I feel really silly now <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 14 Aug 2014 09:53:17 GMT https://community.qlik.com/t5/QlikView/Problem-with-max-values/m-p/679667#M475049 2014-08-14T09:53:17Z