Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
Please advise how to get the Grade using if-then conditional statement.
Thank You
Tracy
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
Hi Tracy,
.Hopethis is what you want.
Regards
KC
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
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
KC
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
© 1993-2014 QlikTech International AB
Copyright & Trademarks | Privacy | Terms of Use | Software EULA
using intervalmatch in the script ...
regards
Marco