topic Re: Work out if a particular day falls between two dates. in QlikView https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22147#M3734 <HTML><HEAD></HEAD><BODY><P>Attach sample data please </P></BODY></HTML> Tue, 30 Jan 2018 11:34:41 GMT shekhar_analyti 2018-01-30T11:34:41Z Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22146#M3733 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table with 2 dates in it, and this is linked to another (by a unique ID 'MyID') table containing all the dates between these 2 dates, which is then linked to a calendar table, so I can count the number of days between the dates within any given period within the calendar. This all works fine.</P><P></P><P>Now if I select a particular week (worked out already by the calendar) I want show whether the Thursday of that week is counted for each 'MyID' that has days that fall within that week.</P><P></P><P>Does that make sense?</P><P></P><P>I also want to shift the week looked at back by 3 days to the preceding Friday, and count the number of days included between that Friday and the Thursday of the selected week.</P><P></P><P>This even sounds confusing to me so i'll make up a mock .qvw and post it. Please feel free to throw out ideas in the meantime <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 30 Jan 2018 11:31:03 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22146#M3733 quilldew 2018-01-30T11:31:03Z Re: Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22147#M3734 <HTML><HEAD></HEAD><BODY><P>Attach sample data please </P></BODY></HTML> Tue, 30 Jan 2018 11:34:41 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22147#M3734 shekhar_analyti 2018-01-30T11:34:41Z Re: Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22148#M3735 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>1)</P><P>So in the 'Details' Table I would like to include a Boolean that shows 'Y' if the Thursday AND Friday are included as ReferenceDate's for the week selected in the 'Weekly Count' table.</P><P></P><P>2)</P><P>There is a count in the 'Details' table that counts the number of <SPAN style="font-size: 13.3333px;">ReferenceDate's that fall within the week selected in the 'Weekly Count' table. I would also like to include a count that shifts the week looked at backwards by 3 days, ie: back to the preceding Friday, and counts how many <SPAN style="font-size: 13.3333px;">ReferenceDate's fall within that date and the Thursday within the week selected in the 'Weekly Count' table.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Whew.</P></BODY></HTML> Tue, 30 Jan 2018 12:05:32 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22148#M3735 quilldew 2018-01-30T12:05:32Z Re: Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22149#M3736 <HTML><HEAD></HEAD><BODY><P>Would you be able to provide the numerical output you are looking for (may be in an Excel file)?</P></BODY></HTML> Tue, 30 Jan 2018 12:48:35 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22149#M3736 sunny_talwar 2018-01-30T12:48:35Z Re: Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22150#M3737 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Please see attached excel doc with expected output for selected week beginning 22/01/2018.</P></BODY></HTML> Tue, 30 Jan 2018 13:27:23 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22150#M3737 quilldew 2018-01-30T13:27:23Z Re: Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22151#M3738 <HTML><HEAD></HEAD><BODY><P>Check attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191867_Capture.PNG" style="height: 167px; width: 620px;" /></P></BODY></HTML> Tue, 30 Jan 2018 13:37:59 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22151#M3738 sunny_talwar 2018-01-30T13:37:59Z Re: Work out if a particular day falls between two dates. https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22152#M3739 <HTML><HEAD></HEAD><BODY><P>You, Sunny, are a Genius.</P><P></P><P>Cannot thank you enough. Until next time <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 30 Jan 2018 14:49:56 GMT https://community.qlik.com/t5/QlikView/Work-out-if-a-particular-day-falls-between-two-dates/m-p/22152#M3739 quilldew 2018-01-30T14:49:56Z