Discussion Board for collaboration related to QlikView App Development.
I have two tables along with the SQL Query as below:
SELECT A1.ID, B1.Grade, sum(A1.Age) from Table_A A1
INNER JOIN Table_B B1 ON A1.ID = B1.ID AND A1.DateOfBirth BETWEEN B1.Start_Date AND B1.End_Date
where A1.DateOfBirth BETWEEN '1-1-1990' AND '31-12-2006'
AND A1.Subject = 'Math'
group by A1.ID, B.Grade
How to convert this Statement to QlikView Script? Can we use IntervalMatch?
May be this
(html, codepage is 1252, embedded labels, table is @1);
(html, codepage is 1252, embedded labels, table is @2);
Inner Join (TableA)
DROP Table TableB;
View solution in original post