This content has been marked as final. Show 5 replies
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