Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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