topic Comparasion in Set Analysis with variables in QlikView

Comparasion in Set Analysis with variables

Wed, 22 Jun 2011 09:26:22 GMT

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

Thu, 23 Jun 2011 08:47:23 GMT

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

kaushiknsolanki — Thu, 23 Jun 2011 09:23:33 GMT

Hi,

Is it possible for you to upload the qvw file.

Regards,

Kaushik Solanki

Re: Comparasion in Set Analysis with variables

Thu, 23 Jun 2011 10:07:20 GMT

Yes Sure. Thanks for your help.

You can see my problem in the second TAB Feuille 1

Comparasion in Set Analysis with variables

kaushiknsolanki — Thu, 23 Jun 2011 10:25:13 GMT

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

Thu, 23 Jun 2011 10:49:29 GMT

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

Fri, 24 Jun 2011 08:32:16 GMT

Hello,

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

Comparasion in Set Analysis with variables

kaushiknsolanki — Fri, 24 Jun 2011 08:45:25 GMT

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

Fri, 24 Jun 2011 08:59:18 GMT

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

kaushiknsolanki — Fri, 24 Jun 2011 09:19:43 GMT

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

Fri, 24 Jun 2011 09:30:02 GMT

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

Mon, 27 Jun 2011 08:24:10 GMT

I have found the answer.

To do this, you must use the Calculated Dimension :

=AGGR(IF(num((Date(Min(CALENDRIER_Choix.Date_Choix),'DD/MM/YYYY')-date([RECEVEUR.Date de Naissance],'DD/MM/YYYY'))/365)>=18,'Adulte','Enfant'),KEY_RECEVEUR)

Thanks for your help.

Kind Regards,

Bruno Martins Lêdo