11 Replies Latest reply: Jun 27, 2011 4:24 AM by Bruno Martins Lêdo

# Comparasion in Set Analysis with variables

Hello,

I have a issue with one of my KPI:

I need do a sum of one of my column, it's a number of persons.

But I want do this count with dimension category and a dimension Adult/Children.

My problem is that dimension Adult CHildren is not fixed. I need calcul with the birthday and a date selectioned by the user in a calendar, the age of each personne and count the person in the field Adult or Childre.

For this, I have create in a multidimensional chart, with one dimension : Category and two expressions :

One for count the numbers of persons in Adult and the other for Children.

I have create three variables :

```LET vSetAge     =  num((Date(Min(CALENDRIER_Choix.Date_Choix),'DD/MM/YYYY')-date([RECEVEUR.Date de Naissance],'DD/MM/YYYY'))/365)
LET vSetAdulte =  IF(num((Date(Min(CALENDRIER_Choix.Date_Choix),'DD/MM/YYYY')-date([RECEVEUR.Date de Naissance],'DD/MM/YYYY'))/365)>=18,1,0)=1
LET vSetEnfant = IF(num((Date(Min(CALENDRIER_Choix.Date_Choix),'DD/MM/YYYY')-date([RECEVEUR.Date de Naissance],'DD/MM/YYYY'))/365)<18,1,0)=1
```

And my expression is :

```Sum({<\$(vSetAdulte)>}[Nb Mise en attente])
```

When I put the variable vSetAdulte like an expression I have 1 or 0 in the column but in the set analysis it's not works....I don't have nothing in my column. Can you help me please? I have past one day with many forms but I don't understand why it's not works.

Kind Regards,

Bruno

• ###### Comparasion in Set Analysis with variables

Hello,

Nobody have idea please it's crucial for me, if you have idea or commentary don't hesitate

Kind Regards,

Bruno

• ###### Comparasion in Set Analysis with variables

Hi,

Is it possible for you to upload the qvw file.

Regards,

Kaushik Solanki

• ###### Re: Comparasion in Set Analysis with variables

Yes Sure. Thanks for your help.

You can see my problem in the second TAB Feuille 1

• ###### Comparasion in Set Analysis with variables

Hi,

As per the data what ever you have done is right.

Can you describe me what you want.

Regards,

Kaushik Solanki

• ###### Re: Comparasion in Set Analysis with variables

Hello,

Have you an Idea for this after I explain my problem?

• ###### Comparasion in Set Analysis with variables

Hi,

Your set analysis is not proper. Can you please explain in detail what you want with an example.

If possible give the desired output in table.

Regards,

Kaushik Solanki

• ###### Re: Comparasion in Set Analysis with variables

I want calcul the number of Operations preview after the date I have choose in the calendar.

And I want 3 KPI :

- The number total of operations

- The number of Operation who concern an adult (have more or equal of 18 year)

- The number of Operation who concern a child (Have less of 18 year old)

To count an operation in the KPI : We need see if the date of Attente is more importante or equal at the date choose by the user.

 Person BirthDate A 01/01/1980 B 01/06/2007 C 01/06/2002 D 01/09/1975

 Personn Date of Attente Nb Operations CAT A 01/01/2010 1 1 A 02/05/2015 1 2 B 02/06/2024 3 2 C 06/03/2015 2 1 C 06/06/2000 3 3

And the result is :

 I choose the date 01/02011 CAT Nb TOTAL Adult TOTAL Children TOTAL 1 2 2 0 2 4 1 3 3 3 0 3

I hope it's help you to understand? The age need be calculated for all changement by the user of the date choose.

Kind regards,

Bruno Martins Lêdo

• ###### Comparasion in Set Analysis with variables

Hi,

In your example which field is used for CAT,NB, Date of attente, Person, Birthdate,Selected Date.

Regards,

Kaushik Solanki

• ###### Re: Comparasion in Set Analysis with variables

For CAT is : GREFFE.Greffon Prelevé

NB : FAIT.Nb mise en attente

Person : KEY_RECEVEUR

Birthdate : RECEVEUR.Date de Naissance

Selected Date : CALENDRIER_Choix.Date_Choix

Date of Attente : [Date fin Attente]

AND one more thing : Date_Inscription_Administrative need be < at the CALENDRIER_Choix.Date_Choix

[EQUIPE_N.Inter-Région_CO]-={'?','H','C'},

[GREFFE.Organe ou tissu Prelevé]={'O'},

[GREFFE.Greffon Prelevé_CO]={'C','CP','F','I','IL','PA','PO','R'}

You can see this conditions in the file Expressions.txt the first line.

Thank you very much for your help.

Kind Regards,

Bruno Martins Lêdo

• ###### Re: Comparasion in Set Analysis with variables

In the Feuille 1. Normaly I have a column TOTAL, and After TOTAL NR. It's work normaly but I want too A column with the KPI for Only TOTAL Adult personn, TOTAL Adul Personn NR, and the same for Children.

I want 6 colmun in this table.

My problem, is when I want use my Variables in the set Analysis, I don't have any number but only '-' values because I don't succeed calcul the set Analysis to see if a Personn was Adult Or Children in the date choose by the user.

• ###### Re: Comparasion in Set Analysis with variables

To do this, you must use the Calculated Dimension :