topic Re: How to get second max value from result of aggr function in QlikView https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287944#M859546 <HTML><HEAD></HEAD><BODY><P>Awesome, please close this thread by marking the correct response.</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sat, 21 Jan 2017 15:08:58 GMT sunny_talwar 2017-01-21T15:08:58Z How to get second max value from result of aggr function https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287941#M859543 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new to qlikview, </P><P>Am looking to find second max value from result of aggr function </P><P>Here I attached the query ,</P><P></P><P>From this expression i need second max value </P><P></P><P><IMG alt="Untitled1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150261_Untitled1.png" style="height: 348px; width: 620px;" /></P><P>Regards,</P><P></P><P>UdaYeah</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287941#M859543 2020-11-25T16:16:04Z Re: How to get second max value from result of aggr function https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287942#M859544 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Max(Aggr(Count(Empp_ID), Technology<SPAN style="color: #ff0000;">, 2</SPAN>)</STRONG></P></BODY></HTML> Fri, 20 Jan 2017 16:53:33 GMT https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287942#M859544 sunny_talwar 2017-01-20T16:53:33Z Re: How to get second max value from result of aggr function https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287943#M859545 <HTML><HEAD></HEAD><BODY><P>Thank you sunny am getting ans as i expected.....</P><P></P><P>Regards,</P><P>Udayeah</P></BODY></HTML> Sat, 21 Jan 2017 06:08:03 GMT https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287943#M859545 2017-01-21T06:08:03Z Re: How to get second max value from result of aggr function https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287944#M859546 <HTML><HEAD></HEAD><BODY><P>Awesome, please close this thread by marking the correct response.</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sat, 21 Jan 2017 15:08:58 GMT https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287944#M859546 sunny_talwar 2017-01-21T15:08:58Z Re: How to get second max value from result of aggr function https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287945#M859547 <HTML><HEAD></HEAD><BODY><P>Sunny, </P><P></P><P> I don't know how to do that, i can't find that option </P><P></P><P>Regards,</P><P>Udayeah</P></BODY></HTML> Fri, 27 Jan 2017 08:45:29 GMT https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287945#M859547 2017-01-27T08:45:29Z Re: How to get second max value from result of aggr function https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287946#M859548 <HTML><HEAD></HEAD><BODY><P>Did you look at the link I provided, it provide all the details on how you can mark correct and helpful responses</P></BODY></HTML> Fri, 27 Jan 2017 10:09:09 GMT https://community.qlik.com/t5/QlikView/How-to-get-second-max-value-from-result-of-aggr-function/m-p/1287946#M859548 sunny_talwar 2017-01-27T10:09:09Z