topic Re: Need help with Interval match in QlikView

Need help with Interval match

aarohipatel — Tue, 28 Jun 2016 14:12:57 GMT

Hi ,

I have a date field and having difficulty in selecting 'From Date' and "To Date'. Since there are more than 2000 dates in the 'DATE' list box, and want o select for example 09/08/2015 thru 09/21/2015, having difficulty in selecting the date range. So thinking to have two list boxes . one for 'From date' and the other for 'To Date'.

Attached is the qvw in which I have tried to use Interval Match but was not successful. Please correct me on where did I go wrong and also, please suggest of any other better approaches you can think of for this kind of requirement.

Thanks in Advance

Re: Need help with Interval match

sunny_talwar — Tue, 28 Jun 2016 14:16:51 GMT

I am not sure what you are intervalMatching on as DATE and RangeDate are the same for all rows (since you have created DATE as RangeDate)

Are you having trouble implementing this?

Selecting Arbitrary Date Ranges

Re: Need help with Interval match

florentina_doga — Tue, 28 Jun 2016 14:18:19 GMT

per product or no ?

Re: Need help with Interval match

florentina_doga — Tue, 28 Jun 2016 14:27:10 GMT

use variable. see attach

Re: Need help with Interval match

aarohipatel — Tue, 28 Jun 2016 19:15:02 GMT

Hi Sunny,

Thanks for directing me to the correct video. It has couple UI options and clear explanation of implementation. This is what I was trying to implement. I guess I was using the wrong function.

Thanks

Re: Need help with Interval match

sunny_talwar — Tue, 28 Jun 2016 19:16:00 GMT

Super, I am glad I was able to guide you in the right direction