Set analysis at qlikview

[#1]

Hello everyone.

I'm a new user of Qlikview as a debutant and I'm working on an application now.

I want to use set analysis in restitution and I need help please.

first of all if you have a manual of set analysis, it's  helpful to share it . 

I don't know how to filter in the same expression on tow different axes using an < OR > operator.

here is the example:

===================Using < AND > operator============

sum({1 <[Code Etat]= {"Anciennes alertes"}, Exercice= {'2014'} >} Prime_annuelle)

My question is how to work with the same elements using an OR operator.

I have an other question please, in the same example, how to have the sum of (Prime_annuelle) while [Code Etat]= {"Anciennes alertes"}, and depending ONLY of the selection of Exercice. not depending on others axes selection. 

I tried this:

sum({$ <[Code Etat]= {"Anciennes alertes"}, Police= , Date= , Raison_soc= , Ville= , ...>} Prime_annuelle) , It works but I have to put all the 20 axes that I have, and it's no possible neither optimal.

Please help me by responding on those questions.

I'll be waiting for you.

Thanks a lot.

[Anonymous]

Hi Hind,

An "OR" in set analysis is a union of two sets. You do a union with the "+" operator like so:

sum({1 <[Code Etat]= {"Anciennes alertes"}>+<Exercice= {'2014'} >} Prime_annuelle)

Regards

Neetha

[#3]

I'm so sorry to say that it doesn't work. It doesn't give what I want.

and the result is depending on selections.
the sum of <Prime_annuelle> is for all the exercises and all the <[Code Etat]> .

Thanks for helping me.

[#4]

Hi Hind,

please see the below link, gives a good overview of set analysis

http://community.qlik.com/docs/DOC-4951

hope that helps

Joe

[#5]

thanks a lot.

if it doesn't help for this one, it will for more others.

Regards