topic Grade Condition in QlikView

Grade Condition

tracycrown — Sat, 08 Nov 2014 01:33:15 GMT

Dear all

Please advise how to get the Grade using if-then conditional statement.

Thank You

Tracy

Re: Grade Condition

jyothish8807 — Sat, 08 Nov 2014 03:55:44 GMT

Hi Tracy,

.Hopethis is what you want.

Regards

Re: Grade Condition

MarcoWedel — Sat, 08 Nov 2014 14:06:18 GMT

Hi,

one possible solution could be to use the intervalmatch function in the script to generate a new grade field in the student table:

tabGrade:
LOAD *
FROM [http://community.qlik.com/servlet/JiveServlet/download/652029-136441/Testing.xlsx] (ooxml, embedded labels, table is Grade);

tabStudent:
LOAD *
FROM [http://community.qlik.com/servlet/JiveServlet/download/652029-136441/Testing.xlsx] (ooxml, embedded labels, table is Student);

tabLink:
IntervalMatch (Result)
LOAD Lower,Upper
Resident tabGrade;

Left Join (tabStudent)
LOAD Distinct
  Result,
  Max(Lower) as Lower,
  Max(Upper) as Upper
Resident tabLink
Group By Result;

Left Join (tabStudent)
LOAD Grade,
     Lower,
     Upper
Resident tabGrade;

DROP Table tabLink;

DROP Fields Lower, Upper From tabStudent;

hope this helps

regards

Marco

Re: Grade Condition

tracycrown — Sat, 08 Nov 2014 14:17:55 GMT

Dear Jyothish Kc

Thanks for your quick response, please advise how to get the same answer but not to hard code the condition ?.

Thank You

Tracy

Date: Fri, 7 Nov 2014 22:56:11 -0500

From: qcwebmaster@qlikview.com

To: tracycrown@hotmail.com

Subject: Re: - Grade Condition

Qlik Community

Grade Condition

reply from Jyothish Kc in New to QlikView - View the full discussion

Hi Tracy,

.Hopethis is what you want.

Regards

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

Following Grade Condition in these streams:

Inbox

Re: Grade Condition

MarcoWedel — Sat, 08 Nov 2014 14:29:50 GMT

using intervalmatch in the script ...

regards

Marco