Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

praveenkumar_s
Contributor II

Need to get maximum event based on crash

Friends,

Need to get the maximum event which cause the crash in the KPI object as shown in the below image consists of data,

 

eventcrash
A10
B5
C2
A15
B2

I need an KPI object which shows that Event "A" because it has more crash (25). Any Knowledge share will be really thankfull.

1 Solution

Accepted Solutions

Re: Need to get maximum event based on crash

May be this

FirstSortedValue(event, -Aggr(Sum(crash), event))

2 Replies

Re: Need to get maximum event based on crash

May be this

FirstSortedValue(event, -Aggr(Sum(crash), event))

praveenkumar_s
Contributor II

Re: Need to get maximum event based on crash

Thank you very much sunny, It works as expected.