Classification based on calculated value

Sat, 05 Dec 2015 07:14:10 GMT

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;

Re: Classification based on calculated value

swuehl — Sat, 05 Dec 2015 15:10:04 GMT

See answers in your other thread:

Classification based on calculated range in load script

topic Classification based on calculated value in QlikView

Classification based on calculated value

Re: Classification based on calculated value