Documents for QlikView related information.
Beginners in Qlikview I am back with another scenario i.e. Interval Match.
I have two tables Employees, Job grades. The task here is to find out the Grade level of the employees. The same can be achieved in SQL as below using joins
Where employees.SALARY >= job_grades.LOWEST_SAL and employees.SALARY <= job_grades.HIGHEST_SAL
Coming to Qlik view we do a interval match for this, the following code is what I used.
(ooxml, embedded labels, table is employees);
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Note: One noticeable point here is, I couldn't get rid of the synthetic keys. Is there a way that can be done.
Hope this helps.
The synthetic key generated by IntervalMatch() is completely harmless and quite efficient, there's usually no need to remove it. However, if you want to do it anyway check out this document:
IntervalMatch and Slowly Changing Dimensions
Very Helpful 🙂
Awesome .. its good to see joins in this way useful.
this is very help full beginners,
thanks kiran sir
FROM [lib://data/job grades.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
inner join (Employees)
drop table Job_grades;