topic Re: Set Analysis problem in QlikView

Set Analysis problem

djallelsadki — Sun, 06 Sep 2015 16:47:07 GMT

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

Re: Set Analysis problem

petter — Sun, 06 Sep 2015 18:36:38 GMT

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...

Re: Set Analysis problem

djallelsadki — Mon, 07 Sep 2015 05:49:08 GMT

Hi,

I'm sorry but this is not working

Best regards,

D.Sadki

Re: Set Analysis problem

jonathandienst — Mon, 07 Sep 2015 09:38:30 GMT

>>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?

Re: Set Analysis problem

djallelsadki — Mon, 07 Sep 2015 10:16:03 GMT

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

Re: Set Analysis problem

djallelsadki — Mon, 07 Sep 2015 12:43:47 GMT

I found the solution

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

Thanks