Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Keitaru
Creator II
Creator II

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 (2)
0 Replies