Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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