1 Reply Latest reply: Dec 5, 2015 10:10 AM by Stefan Wühl RSS

    Classification based on calculated value

    Dingyong Huang

      Hi all

       

      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 

      NoConcatenate 

      DEP_AIRPORT_INDEX: 

      LOAD *, 

      (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

      NoConcatenate

      DEP_AIRPORT_GRADE:

      LOAD*,

      if (DEP_AIRPORT_INDEX<=fractile(DEP_AIRPORT_INDEX,0.25),'D',

      if (fractile(DEP_AIRPORT_INDEX,0.25)<DEP_AIRPORT_INDEX<=fractile(DEP_AIRPORT_INDEX,0.5),'C',

      if (fractile(DEP_AIRPORT_INDEX,0.5)<DEP_AIRPORT_INDEX<=fractile(DEP_AIRPORT_INDEX,0.75),'B',

      if (fractile(DEP_AIRPORT_INDEX,0.75)<DEP_AIRPORT_INDEX,'A', 'NULL')))) as GRADE_DEP_AIRPORT

      FROM DEP_AIRPORT;