topic Re: Set analysis show value where most recent sale was made in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927903#M321066 <HTML><HEAD></HEAD><BODY><P>Not sure why you want to use set analysis, for expression with company as dimension you can use</P><P></P><P>FirstSortedValue(Sale,-Month)</P></BODY></HTML> Fri, 28 Aug 2015 12:08:25 GMT stigchel 2015-08-28T12:08:25Z Set analysis show value where most recent sale was made https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927901#M321064 <HTML><HEAD></HEAD><BODY><P>I am trying to build a set analysis that would give me a value where most recent sale was made. </P><P></P><P>My data is as following:</P><P>Month&nbsp;&nbsp; Sale&nbsp;&nbsp;&nbsp; Company</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P></P><P>In this case I would like to see the following</P><P></P><P>Company&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sale</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P></P><P>Any suggestions?</P></BODY></HTML> Fri, 28 Aug 2015 11:47:23 GMT https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927901#M321064 terezagr 2015-08-28T11:47:23Z Re: Set analysis show value where most recent sale was made https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927902#M321065 <HTML><HEAD></HEAD><BODY><P>Use the firstsortedvalue function: firstsortedvalue( Sale, -Month)</P></BODY></HTML> Fri, 28 Aug 2015 12:07:11 GMT https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927902#M321065 Gysbert_Wassenaar 2015-08-28T12:07:11Z Re: Set analysis show value where most recent sale was made https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927903#M321066 <HTML><HEAD></HEAD><BODY><P>Not sure why you want to use set analysis, for expression with company as dimension you can use</P><P></P><P>FirstSortedValue(Sale,-Month)</P></BODY></HTML> Fri, 28 Aug 2015 12:08:25 GMT https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927903#M321066 stigchel 2015-08-28T12:08:25Z Re: Set analysis show value where most recent sale was made https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927904#M321067 <HTML><HEAD></HEAD><BODY><P>Check the qvw.</P><P>Hope it helps you...</P></BODY></HTML> Fri, 28 Aug 2015 12:51:42 GMT https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927904#M321067 kavita25 2015-08-28T12:51:42Z Re: Set analysis show value where most recent sale was made https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927905#M321068 <HTML><HEAD></HEAD><BODY><P>Brilliant, thank you...not sure why I was immediately thinking about set analysis <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 28 Aug 2015 13:54:39 GMT https://community.qlik.com/t5/QlikView/Set-analysis-show-value-where-most-recent-sale-was-made/m-p/927905#M321068 terezagr 2015-08-28T13:54:39Z