Hi all,
I have 2 set of data, one is region with user permission, another one is KPI per region / country / city
Hierarchy for location:
+-- North America
| +-- USA
| | +-- New York
| | +-- Boston
| +-- Canada
| | +-- Vancouver
| | +-- Toronto
Permission
NTNAME | ROLE |
---|
MA1 | * |
MA2 | New York |
MA2 | Boston |
MA2 | Toronto |
MA3 | Vancouver |
KPI
LV | KPI |
---|
New York | 1.5 |
Boston | 1.2 |
USA | 1.8 |
Vancouver | 1.3 |
Toronto | 1.7 |
Canada | 1.6 |
North America | 2.0 |
I want to retrieve the KPI based on the user selection and their permission, which is
MA1
- When select nothing: KPI = 2.0
- When select USA: KPI = 1.8
- When select Boston: KPI = 1.2
- When select both Boston and New York: KPI = 1.8 (USA)
MA2
- When select nothing: KPI = 1.8 (USA, second level of hierarchy)
MA3
- When select nothing: KPI = 1.3 (Vancouver, third level of hierarchy)
Is it possible to do in QlikView?
Thanks in advance