Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master Calendar

Hi..

I have to create a master calendar for the  below sample data

   

MARCreated DateClosed Date
ABC16/1/20156/1/2015
ABC26/2/20156/2/2015
ABC36/3/20156/3/2015
ABC45/4/2015

6/3/2015

The selection made on the date should work both for CreatedDate and Closed Date

Thanks         

3 Replies
Kushal_Chawda

Please see the attached

jagan
Partner - Champion III
Partner - Champion III

Hi,

Check this link

Canonical Date

Regards,

Jagan.

marcel_olmo
Partner Ambassador
Partner Ambassador

Hi Senthil,

you need to use the function Intervalmatch().

Here's a solution of what you need.

Regards, M.