Thanks Karthik for replying.
Just to elaborate on this , what i am looking for is below (example) . I have an excel sheet which is calculating region wise supplier ranking .
| Region | Supplier Name | KPI1 index | KPI2 index | KPI3 index | Weight KPI1 | Weight KPI2 | Weight KPI3 | Average weights
(Weight*KPI's) | Rank region wise |
| APAC | xyz1 | 5.5 | 4 | 10 | 10% | 30% | 60% | 7.75 | 1 |
| APAC | xyz2 | 6 | 5 | 9 | 10% | 30% | 60% | 7.5 | 2 |
| APAC | xyz3 | 4.5 | 6 | 6 | 20% | 30% | 50% | 5.7 | 3 |
| Europe | abc4 | 3 | 5 | 5 | 30% | 30% | 40% | 4.4 | 1 |
| Americas | ghi5 | 3.5 | 7 | 7 | 20% | 25% | 55% | 6.3 | 1 |
| Americas | ghi6 | 3.5 | 3 | 8 | 10% | 30% | 60% | 6.05 | 2 |
Weight KPI 1 , Weight KPI 2,Weight KPI 3 - To be hardcoded in Qliksense .
Average weights - Calculation to be done in Qliksense
(Weight*KPI's)
Rank region wise - Calculation to be done in Qliksense ,Output from Qliksense
