Discussion board where members can get started with QlikView.
Need to get the maximum event which cause the crash in the KPI object as shown in the below image consists of data,
I need an KPI object which shows that Event "A" because it has more crash (25). Any Knowledge share will be really thankfull.
May be this
FirstSortedValue(event, -Aggr(Sum(crash), event))
View solution in original post
Thank you very much sunny, It works as expected.