Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Keitaru
Creator
Creator

How to display 2 values if they are tied for first place via FirstSortedValue()

Hi Need some help here. 

Want to know how do I display 2 items that are tied in rank using FirstSortedValue() 


1) by Created Week  - FirstSortedValue(Distinct [L3 Stream],-Aggr(Count(Distinct {<[Problem Created Date]={'>=$(=WeekStart(today(),0,0))<=$(=WeekEnd(today(),0,7))'}>} [Problem ID*+]),[L3 Stream]),1)

2) by Created Month - FirstSortedValue(Distinct [L3 Stream],-Aggr(Count(Distinct {<[Status*]-={'Draft','Cancelled'},[Problem Created Date]={'>=$(=MonthStart(today(),0))<=$(=MonthEnd(today(),0))'}>} [Problem ID*+]),[L3 Stream]),1)

Want the top 2 to show both tied items instead of just 1 item.

Cash & Payment,  Digital Banking Technology

FirstsortedValue.PNG

Labels (3)
0 Replies