topic Interval Match in QlikView

Interval Match

Sat, 26 Jul 2014 13:31:19 GMT

I have attached document and data file can anyone help in matching interval in straight table I am missing something.

I want to get grade student corresponding to Total score

Re: Interval Match

Sat, 26 Jul 2014 13:42:51 GMT

hic

Re: Interval Match

Sat, 26 Jul 2014 17:30:32 GMT

Hi,

U have different grades and different grading names for same grademax and grademin intervals. Like for example

0-50, u have F as a grade in new grading, Red in school grading and C(26-50) as a grade in old grading. I think, as u have different grades for same intervals, u should make changes in source table if I m not wrong.

Re: Interval Match

aveeeeeee7en — Sat, 26 Jul 2014 19:20:43 GMT

Hi aamir

Try something like this:

Grades:

LOAD GradeID,

GradeMin,

GradeMax,

Grade,

GradingName

FROM

.....\TotalScore.xlsx]

(ooxml, embedded labels, table is Grading);

Scores:

LOAD StudentID,

SectionID,

Score

FROM

.....\TotalScore.xlsx]

(ooxml, embedded labels, table is Total);

Final:

IntervalMatch(Score)

Load

GradeMin ,

GradeMax

Resident Grades;

Also see the Attachment.

Re: Interval Match

Sat, 26 Jul 2014 19:24:46 GMT

thats not issue as one grading type at a time

need to do in straight table as I have to perform what if analysis too