5 Replies Latest reply: Nov 15, 2012 9:47 AM by abhim701 RSS

    Extended Interval match not working

      Hi All,


      I am new to Qlikview and trying to use extended syntax IntervalMatch with dates.


      Attached is the code. I have to join two tables. First table is Transaction tables having SalesID and invoice date and second table has SalesID, start date, end date and zone. I need to join these with SalesID field  and fetch zone based on the condition : Invoice date lies between Start Date and end date.


      I am getting random results with interval match. It is able to resolve year level intervals but not the monthly and daily ones.

      Does  Interval match work with dates? Can anyone please help?


      Thanks in Advance