Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating filters for objects using set analyzes


Hello everyone,

I am creating objects in my project which i am displaying the total sum of Promotions and the sum of Managers Promotions.

I have 2 views: The total of the sum and the partial sum in some areas, represented by the expressions below:

Promotions Total:

sum(Promovidos)

Promotions of Managers Total:

sum([Promovidos a Cargo de Liderança])

Promotions Partial:

sum({<[Diretoria]={"Business Development", "Finance", "General Management", "HR", "Legal", "Market Access & Sales Operatio", "Medical", "Oncology & Hematology", "Specialty Care"}>}Promovidos)

Promotions of Managers Partial:

sum({<[Diretoria]={"Business Development", "Finance", "General Management", "HR", "Legal", "Market Access & Sales Operatio", "Medical", "Oncology & Hematology", "Specialty Care"}>}[Promovidos a Cargo de Liderança])

I am facing a problem when i create a filder of the Areas, it only filter the values of "Promotions Total" and "Promotions of Managers Total"

Attached is the qvw to better understanding.

Anyone could help me to solve this issue?

I need that all objects change their values when filtering the areas.

Thanks

2 Replies
Gysbert_Wassenaar

See attached example. Is that what you're looking for?


talk is cheap, supply exceeds demand
Not applicable
Author


Exactly!!

Thank you Gysbert!!