topic FirstSortedValue and Aggr? in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934457#M322734 <HTML><HEAD></HEAD><BODY><P>I have the following data:</P><P><IMG alt="mlats.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105937_mlats.png" style="width: 620px; height: 216px;" /></P><P>In the straight table (top) the formula for "Assigned" is aggr(FirstSortedValue(AR.MLATS,AR.FullTime),AR.Company) but this is</P><P>returning "Null". There are only two values for MLATS for this account, as shown in the second table box.</P><P></P><P>Why is FSV not working here? Does it not work inside AGGR? (I tried it without the AGGR function, and got the message "Error: can't calculate column"; adding AGGR turned it to Null. ) Also, the formula for "Incoming Lead" in the straight table is Aggr(AR.IncTS,AR.Company), and it works fine.</P><P></P><P>Any thoughts on how I might pick the first of the two MLATS values?</P></BODY></HTML> Wed, 18 Nov 2015 18:32:12 GMT 2015-11-18T18:32:12Z FirstSortedValue and Aggr? https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934457#M322734 <HTML><HEAD></HEAD><BODY><P>I have the following data:</P><P><IMG alt="mlats.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105937_mlats.png" style="width: 620px; height: 216px;" /></P><P>In the straight table (top) the formula for "Assigned" is aggr(FirstSortedValue(AR.MLATS,AR.FullTime),AR.Company) but this is</P><P>returning "Null". There are only two values for MLATS for this account, as shown in the second table box.</P><P></P><P>Why is FSV not working here? Does it not work inside AGGR? (I tried it without the AGGR function, and got the message "Error: can't calculate column"; adding AGGR turned it to Null. ) Also, the formula for "Incoming Lead" in the straight table is Aggr(AR.IncTS,AR.Company), and it works fine.</P><P></P><P>Any thoughts on how I might pick the first of the two MLATS values?</P></BODY></HTML> Wed, 18 Nov 2015 18:32:12 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934457#M322734 2015-11-18T18:32:12Z Re: FirstSortedValue and Aggr? https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934458#M322735 <HTML><HEAD></HEAD><BODY><P>Try to use</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=FirstSortedValue(AR.MLATS, AR.FullTime)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">as expression, not as calculated dimension.<BR /></SPAN></P></BODY></HTML> Wed, 18 Nov 2015 18:42:28 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934458#M322735 swuehl 2015-11-18T18:42:28Z Re: FirstSortedValue and Aggr? https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934459#M322736 <HTML><HEAD></HEAD><BODY><P>Thanks, but I ended up using <SPAN style="font-size: 12pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">date</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">aggr</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">min</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #800000; font-size: 12pt;">AR.MLATS</SPAN><SPAN style="font-size: 12pt;">),</SPAN><SPAN style="color: #800000; font-size: 12pt;">AR.Company</SPAN><SPAN style="font-size: 12pt;">),'MM/DD/YY hh:mm:ss') </SPAN>for the</P><P>first one, and max() for the second one. Works perfectly. </P></BODY></HTML> Wed, 18 Nov 2015 20:14:18 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Aggr/m-p/934459#M322736 2015-11-18T20:14:18Z