Date Range Selection

[#1]

Hello Community,

I have this Date Range Table:

startdate	enddate
06/02/2012	06/11/2012
06/12/2012	06/21/2012
06/22/2012	07/01/2012
07/02/2012	07/11/2012
07/12/2012	07/21/2012
07/22/2012	07/31/2012
08/01/2012	08/10/2012
08/11/2012	08/20/2012
08/21/2012	08/30/2012
08/31/2012	09/09/2012
09/10/2012	09/19/2012
09/20/2012	09/30/2012

I have two other fields named ProductDate and ProductID's, I need to find COUNT of ProductID's for ProductDate between startdate and enddate of above table.

startdate	enddate	ProductCount
06/02/2012	06/11/2012
06/12/2012	06/21/2012
06/22/2012	07/01/2012
07/02/2012	07/11/2012
07/12/2012	07/21/2012
07/22/2012	07/31/2012
08/01/2012	08/10/2012
08/11/2012	08/20/2012
08/21/2012	08/30/2012
08/31/2012	09/09/2012
09/10/2012	09/19/2012
09/20/2012	09/30/2012

I have used hardcoded =count({<ProductDate={'>=06/02/2012<=06/11/2012'} >} ProductID) and this gives correct results, I am unable to link this with the above Date Range Table.

Please if anybody could guide me for this.

Thanks,

itsangad

[#2]

Hello comunity,

I am still waiting for any responses Please share your views on this.

Thanks,

itsangad

[kaushiknsolanki]

HI,

     Have a look at the below links.

     http://community.qlik.com/thread/51150

     http://community.qlik.com/message/14076#14076

     http://community.qlik.com/thread/17039

Regards,

Kaushik Solanki

[#4]

Thanks Kaushik,

Would get back after implementing the approaches.

[sushil353]

hi,

you can use intervalmatch function.

Please find attached sample app

HTH

Sushil