Looking for similar Excel Solution Countifs and Rank Function

Aungo — Sat, 16 Nov 2024 00:51:33 GMT

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

A	B	C	D	E	F	G
Agent	Group	Overall Score	Group Rank	Overall Rank	Group Rank	Overall Rank
Julian Amber	JK Contacts	1.5	2	3	COUNTIFS(B:B,B2,C:C,">"&C2)+1	RANK(C2,$C:$C,0)
Alfredo Salazar	RB Service	1	3	7	COUNTIFS(B:B,B3,C:C,">"&C4)+1	RANK(C3,$C:$C,0)
Lynn Taylor	JK Contacts	2	1	1	COUNTIFS(B:B,B4,C:C,">"&C5)+1	RANK(C4,$C:$C,0)
Francisco Maceda	JK Contacts	1	5	7	COUNTIFS(B:B,B5,C:C,">"&C6)+1	RANK(C5,$C:$C,0)
Adam Waugh	JK Contacts	1	5	7
Jose Ramirez	RB Service	1.2	2	6
Edgar Cabrera	JK Contacts	1	5	7
Harold Willaim	JK Contacts	1.29	4	5
Elias Silverio	JK Contacts	1	5	7
Glen Buttler	RB Service	1.8	1	2
Luis Colin	JK Contacts	1	5	7
John Ali	JK Contacts	1	5	7
Kevin Meg	RB Service	1	3	7
Andres Vargas	JK Contacts	1.3	3	4
Pter Simon	JK Contacts	1	5	7

topic Looking for similar Excel Solution Countifs and Rank Function in QlikView

Looking for similar Excel Solution Countifs and Rank Function