Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Esteemed Contributor

Re: Intervalmatch dates

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
Contributor II

Re: Intervalmatch dates

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

Regards

S

Community Browser