topic Re: To get the In between values between two dates in QlikView

To get the In between values between two dates

Wed, 23 Oct 2013 06:12:21 GMT

Hi all,

I need a help regarding , i have a 'Date' field for that i need to find out the dates which are in between two particular dates let say "1 may 2012" to "31 aug 2013" as a separate filed how it can be achieved. Please help me on the same.

Thanks in advance.

Re: To get the In between values between two dates

sujeetsingh — Wed, 23 Oct 2013 06:16:23 GMT

Why dont you directly derive a field

as :

If(Date>01/05/2012 and Date<31/08/2013 ,Date ,NULL()) as NewDate

Re: To get the In between values between two dates

Wed, 23 Oct 2013 12:00:11 GMT

I tried that, but its not working..

Re: To get the In between values between two dates

saumyashah90 — Wed, 23 Oct 2013 12:03:11 GMT

only({<Date={'>$(SartDate) <$(EndDate)'}>} Date);

Re: To get the In between values between two dates

MayilVahanan — Wed, 23 Oct 2013 12:07:35 GMT

Try in script

If(Floor(Date) >= Num(MakeDate(2012,05,01)) and Floor(Date) <= Num(MakeDate(2013,08,31)), Date ,NULL()) AS NewDate

Re: To get the In between values between two dates

yduval75 — Wed, 23 Oct 2013 12:18:15 GMT

Hello,

You can try this :

If(Date*1>= MakeDate(2012,05,01)*1 and Date*1 <= MakeDate(2013,08,31)*1, Date ,NULL()) as NewDate