Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date interval Issue

Hello Everyone,

I am into a situation wherein I need some help from the community. My requirement is that when I select Month and Year from the Calendar created, suppose Sep 2012, then it must start with 09/30/12 (last date of month) trades and go back in time in 10 day periods to look at the data over the past four months of trades.

Expected Result :

Trade-in Date
6/2/2012 - 6/11/2012
6/12/2012 - 6/21/2012
6/22/2012 - 7/1/2012
7/2/2012 - 7/11/2012
7/12/2012 - 7/21/2012
7/22/2012 - 7/31/2012
8/1/2012 - 8/10/2012
8/11/2012 - 8/20/2012
8/21/2012 - 8/30/2012
8/31/2012 - 9/9/2012
9/10/2012 - 9/19/2012
9/20/2012 - 9/30/2012

Thanks


1 Reply
Not applicable
Author

hi

try this

if(From>To,null(),
only({<Date={'>=$(=Date(From))<=$(=Date(To))'}>} Date))