I have the following script to classify airports based on a calculated index . However, Qlikview keeps detecting an error.
Can anyone help?
My intended outcome should be something like this:
Airport Index Grade
ABC 1.5 C
DEF 2 B
HIJ 2.5 A
//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 ALL THE AIRPORTS AND ITS RESPECTIVE ATTRIBUTES
ASSIGNING GRADES TO THE AIRPORTS
if (fractile(DEP_AIRPORT_INDEX,0.75)<DEP_AIRPORT_INDEX,'A', 'NULL')))) as GRADE_DEP_AIRPORT