Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intervalmatch dates

I am attempting to create an intervalmatch that deals with dates. The issue I am coming across is that one of my ranges is 12/21 (dec 21) to 1/20 (Jan 20). So any data that falls into this date range results in a null. How can I indicate that following Dec comes Jan?

2 Replies
datanibbler
Champion
Champion

Hi,

try adding information about the year to your interval - the numeric value (the sum of days from some date in the past) should then pick it up and you should be fine.

HTH

saurabh5
Creator II
Creator II

try creating a calender table and then use your date with year into consideration.

Regards

S