Set Analysis problem

[djallelsadki]

Hello,

If anyone can help me, thank you in advance

I have a list of students who have expressed wishes (school choice)

I need to calculate the following indicators (by school):

- Number of students rated school (value of the dimension) -> OK

- Number of students rated school in addition to a School "Y" (variable) -> OK

- Number of students who ranked the best school that the school Y -> I need help on this expression

See attached file

Thanks,

Best regards,

D.Sadki

[petter]

I think this expression should do the trick:

I haven't tested it properly against your data - so I will do that and come back to you unless you verify first and confirm...

[djallelsadki]

Hi,

I'm sorry but this is not working

Best regards,

D.Sadki

[jonathandienst]

>>Number of students who ranked the best school that the school Y

This is not clear which is best - the first school or school Y?

[djallelsadki]

Hi,

sorry I misspoke,

The best school is the one that has a lower wish...

Exemple :

StudentKey SchoolKey Wish

146               213           1

146               82             2

146               209           3

146               609           4

146               208           5

146               206           6

146               126           7

146               196           8

146               212           9

146               92             10

146               227           11

SchoolKey Y = 92

Number of student who ranked = 1 ( 9 Wish before the school 92) and so on

I want to count all the student that satisfied this condition in a st table with only School as dimension

Thanks

Best regards,

D.Sadki

[djallelsadki · Accepted solution]

I found the solution

Count(distinct if(aggr(only({1}Wish)-Only({<Y_School_Wish.SchoolKey={"$(vSelectSchool)"}>}Y_Wish),SchoolKey,StudentKey)<0,StudentKey))

Thanks