topic Re: Dates with in a date range in QlikView

Dates with in a date range

Mon, 14 Jul 2014 11:54:45 GMT

Hi All,

I have to find the a set of dates if they lie between a date range or not.. I have tried the same with IF but it does not work for me.

Eg:

Lets say I have place time as 23-Dec-13 and release time as 27-Dec-2013.25-Dec and 26-Dec (Holiday time) falls with in this date range..

I have an inline table and joined it to the table where i get the place time and release time so that IF statement can be used to check the availablity but this logic is not working..

I have used

if(place time <= Holiday Time and Holiday time >= release time ,1,0) as flag

Any suggestions to resoleve this issue are much appreciated.

Thanks

Re: Dates with in a date range

alexandros17 — Mon, 14 Jul 2014 12:10:08 GMT

To achieve the same result you can use "networkday" function, your condition however shoup work, send me your document, i'll take a look

Re: Dates with in a date range

Tue, 15 Jul 2014 08:36:56 GMT

Thank you for the help.. actually networkdays will return me the no of days excluding saturday and sunday as well.. but i need to exclude only sunday so i could not use that.. Thanks again for quick reply...