This content has been marked as final. Show 2 replies
I have the following script to group airports based on a calculated index into A, B, C and D. However, Qlikview keeps detecting and error. Can anyone help?
//CALCULATION OF DEPARTURE AIRPORT INDEX
(DEP_CARRIER/MAX_DEP_CARRIER)+(DEP_FLIGHTS/MAX_DEP_FLIGHTS)+(DEP_DIST_GROUP/MAX_DEP_DIST_GROUP)+(DEP_AIRPORT_COUNT/MAX_DEP_AIRPORT_COUNT) as DEP_AIRPORT_INDEX
Resident DEP_AIRPORT;// THIS IS A TABLE OF THE AIRPORTS WITH ALL OF THEIR RESPECTIVE ATTRIBUTES
//ASSIGNING GRADES TO THE AIRPORTS
if (fractile(DEP_AIRPORT_INDEX,0.75)<DEP_AIRPORT_INDEX,'A', 'NULL')))) as GRADE_DEP_AIRPORT