Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
thanks a lot.
if it doesn't help for this one, it will for more others.
Regards