Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
abonnery
Contributor III
Contributor III

Multiple values for one dimension - In range

Dear Qlik users, 

I have a very simple table with projects and their values (cf image).

project range qs.PNG

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.

 

 

 

Labels (1)
0 Replies