Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenkumar_s
Creator II
Creator 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
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

praveenkumar_s
Creator II
Creator II
Author

Thank you very much sunny, It works as expected.