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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

In Interval records

I have scenario like this , i have two dates to deal with start date and end date ;now i used initiated start dates for creating master calender...so i am only seeing records corresponding to initiated start date selecting(2013,q2);

Capture.PNG.png

how can i show those records which are already started in previous and still active in this 2013 q2..

for example; Start date - 4/1/2011 and End date-9/20/2013; i need to show this record also in 2013, q2 selection..

If i can use Interval match... how can i do it? i do not have 3rd date column to match with interval(start-end date)..

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I think this blog post might be of help: Creating Reference Dates for Intervals


talk is cheap, supply exceeds demand