topic calculation with firstsortedvalue, sum, set, help please in QlikView

calculation with firstsortedvalue, sum, set, help please

shahamel — Thu, 24 Jan 2013 15:37:57 GMT

Dear QV-users

I want to make this calculation:

(PEOPLE_GRADUATED * 100) / TOTAL_PEOPLE

TOTAL_PEOPLE = COUNT ALL PEOPLE

PEOPLE GRADUATED =

TYPE_ONDERWIJS = BO AND

STARTOCTOBER <= DATE_EXIT AND

DATE_EXIT < TODATE AND

(SUCCES = 1 AND X = 1) OR (LEAVVE = 1 AND Y=1)

X = COUNT PEOPLE

WHERE SUCCES = 1

STARTOCTOBER = SCHOOLSTART AND

DATE_EXIT < TODATE

// i want to use firstsortedvalue for sort by.

SORT BY

KWALIFICATION DESC

FUNDED

SIZE EDUCATION

ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC

CONNECTION NUMBER

Y = COUNT PEOPLE

WHERE EXIT = 1

STARTOCTOBER = SCHOOLSTART AND

DATE_EXIT < TODATE

// i want to use firstsortedvalue for sort by.

SORT BY

IF(SUCCES NOTNULL, KWALIFICATION, ElSE 'NIVEAU0)'

FUNDED

SIZE EDUCATION

ISNULL(DATE_EXIT, DATE_ENDPLANNED) DEC

KWALIFICATION DESC

CONNECTION NUMBER

Good luck