topic Re: Select value related on another field in QlikView https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860192#M301167 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution could be:</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">FirstSortedValue</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">Province</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">, -</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Policy ID]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">) </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><IMG alt="QlikCommunity_Thread_162386_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85450_QlikCommunity_Thread_162386_Pic1.JPG" style="height: auto;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><IMG alt="QlikCommunity_Thread_162386_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/85454_QlikCommunity_Thread_162386_Pic2.JPG" style="height: 244px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><IMG alt="QlikCommunity_Thread_162386_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/85455_QlikCommunity_Thread_162386_Pic3.JPG" style="height: 200px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">hope this helps</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">regards</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Marco<BR /></SPAN></P></BODY></HTML> Thu, 30 Apr 2015 21:30:35 GMT MarcoWedel 2015-04-30T21:30:35Z Select value related on another field https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860190#M301165 <HTML><HEAD></HEAD><BODY><P><STRONG>Source Data</STRONG></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="162"><TBODY><TR><TD align="left" class="xl63" height="17" width="54">Name ID</TD><TD align="left" class="xl63" style="border-left: none;" width="55">Policy ID</TD><TD align="left" class="xl63" style="border-left: none;" width="53">Province</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">1</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">111</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">BKK</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">1</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">112</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">CM</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">1</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">113</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">LP</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">2</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">211</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">BKK</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">2</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">212</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">CM</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">2</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">213</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">KKC</TD></TR><TR><TD align="left" class="xl64" height="17" style="border-top: none;">2</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">214</TD><TD align="left" class="xl64" style="border-top: none; border-left: none;">PY</TD></TR></TBODY></TABLE><P></P><P><STRONG>Require Output</STRONG></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD align="left" class="xl65" height="17" width="64">Name ID</TD><TD align="left" class="xl65" style="border-left: none;" width="64">Max Policy ID</TD><TD align="left" class="xl65" style="border-left: none;" width="64"><SPAN style="color: #ff0000;">Province by Max Policy ID</SPAN></TD></TR><TR><TD align="left" class="xl66" height="17" style="border-top: none;">1</TD><TD align="left" class="xl66" style="border-top: none; border-left: none;">113</TD><TD align="left" class="xl66" style="border-top: none; border-left: none;">LP</TD></TR><TR><TD align="left" class="xl66" height="17" style="border-top: none;">2</TD><TD align="left" class="xl66" style="border-top: none; border-left: none;">214</TD><TD align="left" class="xl66" style="border-top: none; border-left: none;">PY</TD></TR></TBODY></TABLE><P></P><P>How about Set Analysis for <SPAN style="font-size: 13.3333330154419px;">Province by Max Policy ID Field ?</SPAN></P></BODY></HTML> Thu, 30 Apr 2015 18:00:48 GMT https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860190#M301165 2015-04-30T18:00:48Z Re: Select value related on another field https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860191#M301166 <HTML><HEAD></HEAD><BODY><P>you can get it by using the firstsorted value</P><P></P><P>=FIRSTSORTEDVALUE (<SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Province </SPAN>, – aggr(max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Policy ID</SPAN>),<SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Province</SPAN>) )</P></BODY></HTML> Thu, 30 Apr 2015 18:39:02 GMT https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860191#M301166 ramoncova06 2015-04-30T18:39:02Z Re: Select value related on another field https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860192#M301167 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution could be:</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">FirstSortedValue</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">Province</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">, -</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Policy ID]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">) </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><IMG alt="QlikCommunity_Thread_162386_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85450_QlikCommunity_Thread_162386_Pic1.JPG" style="height: auto;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><IMG alt="QlikCommunity_Thread_162386_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/85454_QlikCommunity_Thread_162386_Pic2.JPG" style="height: 244px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><IMG alt="QlikCommunity_Thread_162386_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/85455_QlikCommunity_Thread_162386_Pic3.JPG" style="height: 200px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">hope this helps</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">regards</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Marco<BR /></SPAN></P></BODY></HTML> Thu, 30 Apr 2015 21:30:35 GMT https://community.qlik.com/t5/QlikView/Select-value-related-on-another-field/m-p/860192#M301167 MarcoWedel 2015-04-30T21:30:35Z