Creating filters for objects using set analyzes

Fri, 27 Nov 2015 15:51:16 GMT

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

Re: Creating filters for objects using set analyzes

Gysbert_Wassenaar — Fri, 27 Nov 2015 15:58:52 GMT

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

Re: Creating filters for objects using set analyzes

Fri, 27 Nov 2015 17:34:19 GMT

Exactly!!

Thank you Gysbert!!

topic Creating filters for objects using set analyzes in QlikView

Creating filters for objects using set analyzes

Re: Creating filters for objects using set analyzes

Re: Creating filters for objects using set analyzes