topic How to Join tables with comparing dates? in QlikView

How to Join tables with comparing dates?

Tue, 28 Feb 2012 23:21:51 GMT

Hello,

I tried looking for this but could not find a solution. I have two tables that I need to join, but I have to check if the date of the sale's table is between the date of the collection's table. In addition, the brand and category must be the same in both tables.

Sales:
Load Date
         Brand
         Invoice
         Category
         Material
         Sales

The other table

Collections:
Load [Date start]
        [Date end]
        Brand
        Category
        Collection

The result that I want is :

Load Date

Brand

Invoice

Re: How to Join tables with comparing dates?

Tue, 28 Feb 2012 23:39:43 GMT

What you are looking for is known as an extended interval match. If you search the help for "IntervalMatch (Extended Syntax)" you should see how its done.

This will create a mapping table between the 2 tables you have rather than joining them into a single table however and also creates sythetic keys along the way. You can then simply left join the 3 table together to solve both these issues.

How to Join tables with comparing dates?

Thu, 01 Mar 2012 15:13:48 GMT

Thank you very much!!! . I did and it worked as I needed.

Re: How to Join tables with comparing dates?

Fri, 02 Mar 2012 22:17:18 GMT

Glad to help!