Discussion Board for collaboration related to Creating Analytics for QlikView.
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
Go to Solution.
I found the solution
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...
I'm sorry but this is not working
>>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?
sorry I misspoke,
The best school is the one that has a lower wish...
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