topic Firstsortedvalue with condition in QlikView https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252091#M95579 <HTML><HEAD></HEAD><BODY><P>Try to use the set analysis to force that value as a condition:</P><P></P><P>=firstsortedvalue( {&lt;[Item Update Awarded?]={Yes}&gt;}&nbsp; [Item Update Price],-[Item Update Timestamp])</P><P>If it doesn't work, can you share some data so we can reproduce your problem ? </P><P></P><P></P><P>Hope it helps, </P><P></P><P>Erich</P></BODY></HTML> Mon, 30 May 2011 19:47:43 GMT erichshiino 2011-05-30T19:47:43Z Firstsortedvalue with condition https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252090#M95578 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following three fields,</P><P></P><P>[Item Number]</P><P>[Item Update Price]</P><P>[Item Update Timestamp]</P><P>[Item Update Awarded?]</P><P></P><P>I want to show the latest price ([Item Update Price]) per Item Number given that the price has been awarded ([Item Update Awarded?]='Yes')? I have written the following statement and it shows the latest price.</P><P></P><P>=firstsortedvalue([Item Update Price],-[Item Update Timestamp])</P><P></P><P>But I only want to display [Item Update Price] that have the condition [Item Update Awarded?]='Yes'</P><P></P><P>How do I write this?</P><P></P><P>Thankful for any help!</P><P></P><P>Br,</P><P>Jonas</P></BODY></HTML> Mon, 30 May 2011 19:18:18 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252090#M95578 2011-05-30T19:18:18Z Firstsortedvalue with condition https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252091#M95579 <HTML><HEAD></HEAD><BODY><P>Try to use the set analysis to force that value as a condition:</P><P></P><P>=firstsortedvalue( {&lt;[Item Update Awarded?]={Yes}&gt;}&nbsp; [Item Update Price],-[Item Update Timestamp])</P><P>If it doesn't work, can you share some data so we can reproduce your problem ? </P><P></P><P></P><P>Hope it helps, </P><P></P><P>Erich</P></BODY></HTML> Mon, 30 May 2011 19:47:43 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252091#M95579 erichshiino 2011-05-30T19:47:43Z Firstsortedvalue with condition https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252092#M95580 <HTML><HEAD></HEAD><BODY><P>Perfect Erich! Thanks!</P><P></P><P>Didn't know FirstSortedValue was considered an aggregation function.</P><P></P><P>Best Regards,</P><P>Jonas</P></BODY></HTML> Tue, 31 May 2011 05:56:59 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue-with-condition/m-p/252092#M95580 2011-05-31T05:56:59Z