Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
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