Set Analysis and semester dates and situation

[#1]

Hello everyone, I'm new in the community and also in Qlik, need help in a set analysis!

The situation is this, I need to know the number of dropout students of an institution!

Ie have the field situation, semester, year to know this number the formula is as follows:

Evasion = student status (0, inactive) in the current semester and check whether pupils were active (1) in the previous six months, so I will know the number of students who have not activated enrolled in the current semester with reference to the previous semester

thank you

[swuehl]

Would be helpful if you could post some sample data (e.g. an Excel file), also a table with your expected results.

[#3]

Hello , so there you go !
This is the excel , the expected result is the featured table with the color blue, as I said earlier to find the dropout students in the current semester logic would students who were active in the previous semester and not activated enrollment in current semester .
For this work the following loaded BD fields , year, semester , status ( ACTIVE - 1 /0- INACTIVE )
I would have to compare students in the current semester with the previous semester to selected well know the number of students who have INACTIVE status in the current semester and were with the ACTIVE status in the previous semester .

[#4]

Or rather , I will generalize is doubt! I need to know student evasion , ie in the current year is with status 0 ( inactive) and the year before status 1 (active ) , so I can know the number of students who left . I do not know is how to assemble the expression , if you have any example where compare years already help me ! Thank you!