topic Set analysis at qlikview in QlikView

Set analysis at qlikview

Wed, 10 Dec 2014 14:19:12 GMT

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.

Re: Set analysis at qlikview

Anonymous — Wed, 10 Dec 2014 14:34:46 GMT

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

Re: Set analysis at qlikview

Wed, 10 Dec 2014 17:22:46 GMT

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.

Re: Set analysis at qlikview

Wed, 10 Dec 2014 17:27:32 GMT

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

Re: Set analysis at qlikview

Wed, 10 Dec 2014 17:38:29 GMT

thanks a lot.

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

Regards