Retrieve value based on region, permission and user selection

alexlinkreit17 — Mon, 12 Mar 2018 08:55:55 GMT

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

KPI

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

topic Retrieve value based on region, permission and user selection in QlikView