topic Max(total Period) in QlikView https://community.qlik.com/t5/QlikView/Max-total-Period/m-p/217136#M70381 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Have you tried using the function firstsortedvalue? Something like this might work:<BR />=firstsortedvalue(PeriodName, -Period)</P><P>regards<BR />/Fredrik</P></BODY></HTML> Mon, 12 Jul 2010 10:28:22 GMT 2010-07-12T10:28:22Z Max(total Period) https://community.qlik.com/t5/QlikView/Max-total-Period/m-p/217135#M70380 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have 2 expressions for calculating sales</P><P>- one express sums the total sales of all periods selected: Sum(Sales)</P><P>- the other gives you just the total for the most recent period in the range of periods selected: sum(if(max(total Period) = Period,Sales))</P><P>They work fine and I want the second expression to have a custom name so that when the period range is selected the name includes the name of the latest period.</P><P>Our periods are numbers e.g. 11101 is July 2010 which is the first period in FY11, 11102 is August 2010, etc</P><P>the names for these numbers are on a list.</P><P>When I do the name formula I can get the period number but not the period name e.g. = max(total PeriodName) doesnt work but =max(total Period) will return a number</P><P></P><P>any ideas?</P><P>David</P></BODY></HTML> Thu, 08 Jul 2010 02:48:27 GMT https://community.qlik.com/t5/QlikView/Max-total-Period/m-p/217135#M70380 2010-07-08T02:48:27Z Max(total Period) https://community.qlik.com/t5/QlikView/Max-total-Period/m-p/217136#M70381 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Have you tried using the function firstsortedvalue? Something like this might work:<BR />=firstsortedvalue(PeriodName, -Period)</P><P>regards<BR />/Fredrik</P></BODY></HTML> Mon, 12 Jul 2010 10:28:22 GMT https://community.qlik.com/t5/QlikView/Max-total-Period/m-p/217136#M70381 2010-07-12T10:28:22Z