Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set analysis at qlikview

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.

Tags (1)
4 Replies
neetha_p
Honored Contributor

Re: Set analysis at qlikview

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

Not applicable

Re: Set analysis at qlikview

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.

Not applicable

Re: Set analysis at qlikview

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

Not applicable

Re: Set analysis at qlikview

thanks a lot.

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


Regards