Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Looking for similar Excel Solution Countifs and Rank Function

Hi 

I am looking for a similar function to write in Chart Expression (pivot Table)in  Qlikview to calculate Column D and Column E . I have included the formula in respective columns (F & G)

Note that Overall Score 'Column C' was also calculated in Expression and given a variable name varOverall 

Need help here 

Thanks 

ABCDEFG
AgentGroupOverall ScoreGroup RankOverall Rank Group Rank Overall Rank
Julian AmberJK Contacts1.523COUNTIFS(B:B,B2,C:C,">"&C2)+1RANK(C2,$C:$C,0)
Alfredo SalazarRB Service137COUNTIFS(B:B,B3,C:C,">"&C4)+1RANK(C3,$C:$C,0)
Lynn TaylorJK Contacts211COUNTIFS(B:B,B4,C:C,">"&C5)+1RANK(C4,$C:$C,0)
Francisco MacedaJK Contacts157COUNTIFS(B:B,B5,C:C,">"&C6)+1RANK(C5,$C:$C,0)
Adam Waugh JK Contacts157  
Jose RamirezRB Service1.226  
Edgar CabreraJK Contacts157  
Harold WillaimJK Contacts1.2945  
Elias SilverioJK Contacts157  
Glen ButtlerRB Service1.812  
Luis ColinJK Contacts157  
John AliJK Contacts157  
Kevin MegRB Service137  
Andres VargasJK Contacts1.334  
Pter SimonJK Contacts157  
Tags (3)
Labels (3)