Hi All,
I am new to QlikView. I am facinga problem to generate a ranks for two leveled dimesions .Hers is the Example I want to generate a rank to the GROUP based on the Total Sum w.r.t the Group. Reqeust you all to help me on this
| Group | Month | Sum | Rank on Sum | Ranks For Groups based on Total Sum |
| A | 1 | 17 | 2 | 2 |
| A | 4 | 16 | 3 |
| A | 7 | 11 | 4 |
| A | 8 | 20 | 1 |
| A | Total | 64 | - | - |
| B | 2 | 9 | 3 | 4 |
| B | 3 | 22 | 1 |
| B | 5 | 10 | 2 |
| B | 6 | 5 | 4 |
| B | Total | 46 | - | - |
| D | 1 | 21 | 1 | 1 |
| D | 2 | 18 | 2 |
| D | 5 | 15 | 3 |
| D | 8 | 12 | 4 |
| D | Total | 66 | - | - |
| E | 3 | 10 | 3 | 3 |
| E | 4 | 21 | 1 |
| E | 6 | 11 | 2 |
| E | 7 | 6 | 4 |
| E | Total | 48 | - | - |
