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

Announcements
Search may be unavailable 11:30 PM on Aug 24 to 1:30 AM on Aug 25. Thank you for your patience.
cancel
Showing results for 
Search instead for 
Did you mean: 
vkish16161
Creator III
Creator III

Aggr function seems to be not working (Ranking within Aggr)

All, is there anything wrong with the below expression?

 

=Avg(

                               Aggr(

                                          Sum(new_cases),

                                                                              Aggr(

                                                                                          if(Rank(Sum(new_cases))<=50,Country,null()),

                                                                                                                                                                                           Country)


)

)

Labels (2)
0 Replies