Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello comunity,
I am still waiting for any responses Please share your views on this.
Thanks,
itsangad
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
Thanks Kaushik,
Would get back after implementing the approaches.
hi,
you can use intervalmatch function.
Please find attached sample app
HTH
Sushil