Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have monthly scorecard created in a excel, which creates a ranking mechanism based on certain KPI's. To automate this calculations currently happening in excel ,How it can be done in Qliksense ?
Hi Prashanth,
The question is a bit vague.
Please refer to this page for a list of aggregations that are possible:
Using these, you'd then decide on the appropriate chart types and bring up your dashboard.
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