topic Re: Need to get maximum event based on crash in QlikView https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42638#M771833 <HTML><HEAD></HEAD><BODY><P>Thank you very much sunny, It works as expected. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 16 May 2018 14:56:02 GMT praveenkumar_s 2018-05-16T14:56:02Z Need to get maximum event based on crash https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42636#M771831 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P>Need to get the maximum event which cause the crash in the KPI object as shown in the below image consists of data,</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl65" height="20" width="64">event</TD><TD class="xl65" style="border-left: none;" width="64">crash</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD></TR></TBODY></TABLE><P></P><P>I need an KPI object which shows that Event "A" because it has more crash (25). Any Knowledge share will be really thankfull.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42636#M771831 praveenkumar_s 2020-11-25T16:16:04Z Re: Need to get maximum event based on crash https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42637#M771832 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>FirstSortedValue(event, -Aggr(Sum(crash), event))</STRONG></P></BODY></HTML> Wed, 16 May 2018 14:12:49 GMT https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42637#M771832 sunny_talwar 2018-05-16T14:12:49Z Re: Need to get maximum event based on crash https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42638#M771833 <HTML><HEAD></HEAD><BODY><P>Thank you very much sunny, It works as expected. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 16 May 2018 14:56:02 GMT https://community.qlik.com/t5/QlikView/Need-to-get-maximum-event-based-on-crash/m-p/42638#M771833 praveenkumar_s 2018-05-16T14:56:02Z