Assign a range of constant value to a field - case statement in Qliksense - chart level

[gayatri7]

Hello All,

I have below logic similar to case statement that I am trying to achieve in Qliksense - Chart

REPORT	REPORTING LEVEL
10	PLANT
15	SUBZONE
20	ZONE
25	SUBAREA
30	AREA
35	SUBREGION
40	REGION
50	OPCO

Flag value should be as 

WHEN PLANT (10) IS SELECTED THEN 20, 30,40,50,60,70,99,6,11

WHEN OPCO (50) IS SELECTED THEN 60,70,99,6,11,21,31,41,51

WHEN AREA (30) IS SELECTED THEN 40,50,60,70,99,6,11,21,31

Eg in case of 50 , I want output as FLAG ={'60','70','99','6','11','21','31','41','51'}

As I will be using this Flag field in Set expression for next calculation. How can I achieve this Flag value which are fixed number as mentioned above.

Thanks for your help in advance.

Gayatri

[marcus_sommer · Accepted solution]

I think I would apply an as-of-table to associate a reporting-level with overlapping flag-areas. The idea behind it is: (1) The As-Of Table - Qlik Community - 1466130

[gayatri7]

Hello Marcus,

Thanks for providing the suggestion to use As-Of-Table. I guess , I am moving to the right direction.

I have created an as of table and try to get the list of values. And I am getting the expected output

Thanks  for your help and have a nice day!

Gayatri