topic Re: Date range issue ? in QlikView

Date range issue ?

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

We want date field from starting date i.e 3/31/2014 to 9/30/2018 so that if we select any date it has to show in which cycle will fall.

Please help us with this. thanks

CarlosAMonroy — Thu, 06 Jul 2017 15:27:03 GMT

Hi Vishal,

Maybe you can use Interval match function in the script to create the range between the Start and End Dates.

That way if you select any date between will show you the ID related.

Carlos M

Anonymous — Thu, 06 Jul 2017 15:32:34 GMT

have a look here:

jmvilaplanap — Thu, 06 Jul 2017 15:34:32 GMT

I think, you have to use IntervalMatch function