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
| 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 | | |
