Dear Qlik users,
I have a very simple table with projects and their values (cf image).
I am trying to create a dimension to filter the project based on their values.
The values of this dimension would be for example 'Below 1 M€', 'Above 1 M€', 'Above 5 M€', 'Above 15 M€', 'Above 50 M€'. I tried the following script (the following script:
Aggr(if(sum([AED Amount])<1000000,
dual('Below 1M€',1),
if(Sum([AED Amount])>=50000000,
dual('Above 50M€ ',5),
if(Sum([AED Amount])>=15000000,
dual('Above 15M€',4),
if(Sum([AED Amount])>=5000000,
dual('Above 5M€',3),
if(Sum([AED Amount])>=1000000 ,
dual('Above 1M€',2)
))))),[Project Name])
However when I filter when the value 'Above 5 M€' for example, only the projects between 5M€ and 20M€ are shown. There should also be the ones above 100M€.
How do one attribute several dimensions to a field ? It's a problem of creating a multi-dimension I guess.
Thank you very much for your help.