Date interval Issue

Tue, 29 Jan 2013 05:27:37 GMT

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

Re: Date interval Issue

Tue, 29 Jan 2013 05:47:17 GMT

try this

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

topic Re: Date interval Issue in QlikView

Date interval Issue

Re: Date interval Issue