topic Re: Date Range Selection in QlikView

Date Range Selection

Fri, 08 Mar 2013 07:49:40 GMT

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

Re: Date Range Selection

Mon, 11 Mar 2013 06:53:02 GMT

Hello comunity,

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

Thanks,

itsangad

Re: Date Range Selection

kaushiknsolanki — Mon, 11 Mar 2013 06:57:10 GMT

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

Re: Date Range Selection

Mon, 11 Mar 2013 07:07:47 GMT

Thanks Kaushik,

Would get back after implementing the approaches.

Re: Date Range Selection

sushil353 — Mon, 11 Mar 2013 07:09:33 GMT

hi,

you can use intervalmatch function.

Please find attached sample app

HTH

Sushil